Ok.. why is when I use the formule
=roundup(a1,02) is round up stuff like this?
226.9449 will become 226.95 ... how do I get it to be 226.94?
=ROUND(A1,2)
Vaya con Dios,
Chuck, CABGx3
> Ok.. why is when I use the formule
> =roundup(a1,02) is round up stuff like this?
>
> 226.9449 will become 226.95 ... how do I get it to be 226.94?
TaGY2K - 27 Jan 2006 17:37 GMT
how about round down?

Signature
TaGY2K
CLR - 27 Jan 2006 17:51 GMT
In this instance, both ROUND and ROUNDOWN would return the same result.
The HELP file will give you a more in depth explanation of how these
functions work.
Vaya con Dios,
Chuck, CABGx3
> how about round down?
Beege - 27 Jan 2006 17:57 GMT
Look up ROUND in your help file. It will show you your options, including
ROUNDUP and ROUNDDOWN.
Beege
> how about round down?