rounding.

  • Thread starter Thread starter John Nanni
  • Start date Start date
J

John Nanni

I am trying to figure out the formula which will allow me
to round up for any number with a decimal greather
than .25 and round down any number with a decimal that is
less than .25.

For example:

10.3 would be rounded up to 11 because .3 > .25.
11.12 would be rounded down because .12 < .25.

Anyone know how to do this?

Please email response to (e-mail address removed)

Thank you,

j
 
For A1
=IF(MOD(AA1,1)<=0.25, ROUNDDOWN(A1,0), ROUNDUP(A1,0))

You left out exactly = to 0.25 so i assumed it should be rounded down, if it
should be rounded up

=IF(MOD(G85,1)<0.25, ROUNDDOWN(G85,0), ROUNDUP(G85,0))

Dan E
 
Assuming 0.25 is to be rounded up (he didn't say), you could also use

=INT(A1+0.75)

or if you want to do it the hard/long way <g>

=INT(A1)+IF(MOD(A1,1)>=0.25,1,0)
 
Back
Top