# 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.
Saurabh Singh Teotia

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

=round(a1,2)

This will round it two decimal places...

Saurabh....

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...
``=ROUND(A1,2)+0.01``
Saurabh Singh Teotia

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

``=ROUNDUP(A1,2)``
@Saurabh
You were pretty fast on this. :)
@Sktneer,

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.. :-)

Saurabh...
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.