ExcelBanter - How do I round a price up or down to ##.99

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I round a price up or down to ##.99 (https://www.excelbanter.com/excel-discussion-misc-queries/28131-how-do-i-round-price-up-down-99-a.html)

How do I round a price up or down to ##.99

N Harkawat

=ROUND(A1,0)-0.01

"JJ" wrote in message
...

All times are GMT +1. The time now is 03:16 AM.