hi,

try to use:

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

hth
regards from Brazil
Marcelo

"mstack" escreveu:

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