Formula help
On Fri, 13 May 2011 09:33:00 -0700 (PDT), 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.
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.
|