ExcelBanter - how do i roundup a formula result to the nearest unit of 10

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

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

- - how do i roundup a formula result to the nearest unit of 10 (https://www.excelbanter.com/excel-discussion-misc-queries/73483-how-do-i-roundup-formula-result-nearest-unit-10-a.html)

Razza

how do i roundup a formula result to the nearest unit of 10

Bernard Liengme

how do i roundup a formula result to the nearest unit of 10

=ROUND(A1,0)
or
=ROUND(formula,0)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

PS: please put message in white space not in Subject

"Razza" wrote in message
...

All times are GMT +1. The time now is 08:58 AM.