Rounding to the nearest 9th
"Rachael" wrote in message
...
Hi,
I have a variation on this problem. I need to change every price ending in
"0" to one dollar lower. E.g. if it's $100, it needs to display $99.
However,
all other prices can stay the same. Any suggestions?
Thanks!
Assuming all your prices are integers:
=IF(MOD(A1,10)=0,A1-1,A1)
|