rounding a retail amount to the closest .99
Im using Numbers to calculate retails by a flat percentage but wan't to end each price point in .99. What formula do I use to accomplish this?
iMac 21.5″, macOS 12.6
Question marked as
Putting specifics on Jerry's answer....
If your price is in B2.
=ROUND(B2,0)-0.01
Or,
=MROUND(B2,1)-0.01
Or, if you want to force rounding UP, use:
=CEILING(B2,1)−0.01
Or, to force rounding DOWN, use:
=FLOOR(B2,1)−0.01
SG
