Unwanted Rounding

[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!!!

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

 

[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

 

[Arvi Laanemets]

Hi

I'm afraid OP used a simple cell formatting )