• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

round only the 2 digit after . Period

excel700

New Member
Hi all,
I'm new to the forums and new to Round functions . I'm trying to create a custom ROUND function that will allow me to do the following:
round only the 2 digit after period .01
For example:
If i have 8542.01 i want the number 8543.00 that's mean any number >.01 then the result should be added 1 to the fixed number.
i know that's above >.5 excel Automatic round it to top. but here I’m looking even below .5
only for the 2 digit after Period. to be more clear if the 2 digit contain any number then we should round it to top.
i hope my Question is clear and appreciated your helping
Regards,
 
Hi and welcome to the forum Chandoo.org...

can you check this:
=IF(NOT(INT(A2)=A2),INT(A2)+1,A2)
or
=IF(INT(A2)<>A2,INT(A2)+1,A2)
Regards,
 
Hey you can also use the ROUNDUP formula by setting the number format of cell to 2 decimal places and using the formula ROUNDUP(A2,0).

Regards
 
Back
Top