Round formulas
 

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

Round formulas
 

Try this
=IF(MOD(A1,1)=0.7,ROUNDUP(A1,0),ROUNDDOWN(A1,0))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"mstack" wrote in message
...
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

Round formulas
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mstack" wrote in message
...
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

Round formulas
 

Hello Meghan,

=INT(A1+0.3)

HTH,
Bernd

Round formulas
 

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