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