ROUNDING
=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
|