Simple question ...
Have set the cells to Number format and removed decimal places, but i'd also like to have the number present to the nearest ten or hundred etc. How can i set this up?
Ex: 1349, nearest ten 1350, nearest 100 1300
Thanks
Simple question ...
Have set the cells to Number format and removed decimal places, but i'd also like to have the number present to the nearest ten or hundred etc. How can i set this up?
Ex: 1349, nearest ten 1350, nearest 100 1300
Thanks
Hi look into attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Thanks Tom, however if i am unsure of whether i want it to round up CEILING or round down FLOOR is there a combination?! Basically i want it to round up / down like any normal mathematical rounding.
Martyn
Rather than use FLOOR/CEILING you can simply use the ROUND function.
I.e. ROUND(1349,-1)
-1 = nearest 10
-2 = nearest 100
Thanks, so simple as i thought it would be
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks