Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|