ExcelBanter - rounding to nearest 1000

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - rounding to nearest 1000 (https://www.excelbanter.com/excel-programming/379607-re-rounding-nearest-1000-a.html)

Bernard Liengme

rounding to nearest 1000

=ROUND(A1,-3)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"walt" wrote in message
...
I have a permit formula that needs to have any input numbers rounded to the
nearest 1000

Thanks

PS sorry for the last post hit the enter key to fast

All times are GMT +1. The time now is 02:37 AM.