Unwanted Rounding

B

Bigjohn

Hi,

I am tearing my hair out trying to make a currency sum appear to tw
decimal places without the cell being rounded up as, by doing so, i
gives the 'wrong' amount!!!:confused:

For info, the figure in the cell £59.3074. I want it to display £50.3
not £50.31.

Can anyone tell me how to stop it doing this
 
D

Dav

you need to include your formula in another function

eg if your original formula was sum(a1:a2)

eg rounddown(sum(a1:a2),2)
or floor(sum(a1:a2),0.01)

regards

Dav
 
Top