Rounding
Thank you that did it!!!
"Jacob Skaria" wrote:
and what if less than or equal to 0.49
=IF(MOD(A1,1)0.49,ROUND(A1,0),A1)
If this post helps click Yes
---------------
Jacob Skaria
"Lime" wrote:
Hello
Can someone Help me.. I'm stuck!!
can you tell me the formula for round up...after .49? if the number is 7.6..
I want to round to 8.
Any help is greatly appreciated...
Lime
|