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,
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,