Rounding

[Lime]

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

 

[Jacob Skaria]

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

 

[Lime]

Thank you that did it!!!

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

 

[David Biddulph]

If you really want to round up after .49, and down for values below .49 ,
then =INT(A1)+(MOD(A1,1)>0.49)
This would round up for .495
You may need to think about how you want to treat negative numbers.

If you just want to round up for .5 and upwards, and down for values below
..5, then =ROUND(A1,0)

 

[Teethless mama]

=MAX(A1,ROUND(A1,))