ROUNDING

[EDB]

I have a formula e62/c62 - the answer is formatted for %. It is 49.48% when
carried out 2 dec. When carried out 1 is rounds to 49.5%, BUT when I have no
dec. it won't round to 50% - it stays at 49%. I can make it round to 50%,
but how come just formatting it doesn't carry through the standard rounding
up. - Thanks

 

[muddan madhu]

=roundup(e62/c62,2)

 

[Ron Rosenfeld]

I have a formula e62/c62 - the answer is formatted for %. It is 49.48% when
carried out 2 dec. When carried out 1 is rounds to 49.5%, BUT when I have no
dec. it won't round to 50% - it stays at 49%. I can make it round to 50%,
but how come just formatting it doesn't carry through the standard rounding
up. - Thanks

Formatting does not change the underlying value.

The underlying value remains 49.48%

So with "no" decimal places, you are still rounding the value of 49.48.

Since 0.48 is less than 0.5, the Excel algorithm will (properly) return 49.
--ron