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

=roundup(e62/c62,2)


On Oct 17, 8:24*pm, EDB wrote:
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

On Fri, 17 Oct 2008 08:24:01 -0700, EDB wrote:

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