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