Formula help
On May 13, 9:33*am, Anonymous wrote:
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.
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)
|