Formula to Round off Values
Hi All,
I have a query here to write a formula which should round of the values
Example is the value is 16.333 then It should round of the value as 16.34
I mean to say if the third decimal is great than 0.001 then the second value should be rounded as above mentioned in example
This doesn't do what you asked for, but may do what you want:
=CEILING(I29,0.01)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks