Formula help

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

Anonymous

I need a formula that will round down a number if it is less than .75
and round up if it is greater. So, for example, 2.69 would round down
to 2 and 2.89 would round up to 3.

Thanks so much!
 
I need a formula that will round down a number if it is
less than .75 and round up if it is greater.  So, for
example, 2.69 would round down to 2 and 2.89 would round
up to 3.
Click to expand...

If your original number is in A1, ostensibly:

=INT(A1)+(MOD(A1,1)>=0.75)

However, there are many values that might display as x.75 in A1, but
which round down to x using that formula. Perhaps you will be happier
with the results from:

=INT(A1)+(ROUND(MOD(A1,1),2)>=0.75)
 
Back
Top