Round formulas

[Guest]

Hello,

I need a formula that will round up or down based on .7 decimal rather than
..5. For example, the number 45.7 would round up to 46. The number 45.6
would round down to 45.

Is there a formula to help me do this? I appreciate any help I can get.
Thank you.

~Meghan

 

[Bernard Liengme]

Try this
=IF(MOD(A1,1)>=0.7,ROUNDUP(A1,0),ROUNDDOWN(A1,0))
best wishes

 

[Bernard Liengme]

Alternative
=INT(A1)+(MOD(A1,1)>=0.7)

 

[bplumhoff]

Hello Meghan,

=INT(A1+0.3)

HTH,
Bernd

 

[Guest]

hi,

try to use:

=if(c3-int(c3)>=0.6999,(1-(c3-int(c3))+c3),int(c3))

hth
regards from Brazil
Marcelo

"mstack" escreveu: