Rounding a Number Up or Down-Depending on Situation

[Dave Y]

Hello,

I need help in creating a formula for rounding a number
either up or down depending on the situation. For example:
If the value in cell A1 was anywhere between 8.0 to 8.3 I
would want the number to be rounded down to 8; if the
number is from 8.4 to 8.9, I would want the number to be
rounded up to 9. The cut off point of when to round up or
down would be the same no matter what the number is; let's
just say as in this example the cut off to either round up
or down would be the .3 and the .4. Any help with this
formula will be greatly appreciated. Thank you.

Dave Y

 

[Andy B]

Hi

I think the easiest way to do this is to take 0.39 off the figure and round
up to a whole number.
=ROUNDUP(A2-0.39,0)

 

[JulieD]

hi Dave

try

=IF(MOD(A1,1)>=0.4,ROUNDUP(A1,0),ROUNDDOWN(A1,0))

Cheers
JulieD

 

[Dave Y]

Hi Andy,

Thanks for the quick reply. Your response is helpful in
rounding up; but what if the value needs to be rounded
down? Thanks again for your reply.

Dave Y

 

[Andy B]

The way I've done it - by taking off 0.39 first - means that rounding up
does the job. Try it!

 

[Guest]

Hi JulieD,

Thank you for your quick reply. Your solution worked
perfect. I am extremely grateful for your help. Have a
great day.

Dave Y

 

[JulieD]

Hi Dave

glad it worked - however i do think that Andy's solution was a much neater
one than mine ...

Cheers
julieD