Hi,
I currently have this formula:
I9 =sum(G8+H8)*D8
e.g.
G8 = 7.25
H8 = 2
D8 = £3.79
so the I9 cell returns the answer 27.4775.
This, however, is currency (£27.48) and therefore needs to be rounded up/down to the nearest 0.05.
I can do this if I use a separate cell and use =ROUND(I9,2) but I want it all within the same cell.
How do I do it so that it adds G8 & G9 together AND then multiplys that by D8 AND rounds it up/down to 2 decimal places, all within 1 cell?
Kind regards,
Sally
Bookmarks