Formula help

[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!

 

[joeu2004]

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)

 

[Ron Rosenfeld]

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!

What about if the value of the decimal portion is exactly equal to 0.75.

And how do you want to handle negative numbers?

Perhaps:

=ROUND(A1-SIGN(A1)*0.25,0)

This assumes that Round UP/DOWN implies rounding away from or closer to zero.
And also that numbers where the decimal portion is exactly 2.75 will round up.