Link to home
Start Free TrialLog in
Avatar of Star79
Star79Flag for United States of America

asked on

Excel formula Question-Rounding

I have a requirement in my excel sheet that if the cell value is like 128.0304, I have to round it to 128.04, another example 77.001 to 77.01, another example 76.85483 to 76.86.IS this doable in excel formula.
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Use this assuming you got value in A1..then formula in b1 will be...


This will round it two decimal places...

Avatar of Star79


but there is a problem with that rounding as you can see 77.001 is rounding to 77 but it should round to 77.01 also i tried 76.85483 this rounded to 76.85 but I want to see to the next penny which is 76.86
Only rounding will not give you the output you are expecting. You will need to try it like this....
Assuming your number is in A1 then...

Open in new window

Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Or rather use Roundup like this.....


Open in new window

You were pretty fast on this. :)

I need to..I know talented experts like you are here..and if i need to beat you to it..i need to be fast.. :-)

lol. For me it's time to logoff now. See you in another thread. :)
I've requested that this question be closed as follows:

Accepted answer: 500 points for saurabh726's comment #a41388619

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.