mbilko(Elite) posted this on Thursday, 12th September 2013, 17:15
I am trying to set up an excel sheet for the bar here as they always seem to be down on the till , I thought it was easy to add all the denominations using the =sum(b3:b10) but it wont add the pence, 50p, 20p etc....but does add the note totals? not sure how I go about this, duh :(
OK I got it....decimal places....knew it should be easy lol
This item was edited on Thursday, 12th September 2013, 18:37
RE: Excel Question (I thought it was easy)
bandicoot(Elite) posted this on Friday, 13th September 2013, 11:01
Well done.
At least you never asked about Excel formula, I went to a course on that once, and gave up, it was horrible, DOH!
RE: Excel Question (I thought it was easy)
Gaffski(Elite) posted this on Friday, 13th September 2013, 12:08
It might make it easier to read if you apply a custom format of £0.00p to the cells.. Glad you fingured it out!
