Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need help with a formula in excel
trying to create this formula: if a1 is greater than 1 then b1 will equal a1
minus 1 and if a1 equals less than 1 then b1 will equal zero. |
#2
|
|||
|
|||
Hi
What happens when A1 =1 ?? I have allowed for this in the formula below by having A1 <= to 1 Put this in B1 =IF(A11,A1-1,IF(A1<=1,0,"")) HTH Michael "sabretooth54" wrote: trying to create this formula: if a1 is greater than 1 then b1 will equal a1 minus 1 and if a1 equals less than 1 then b1 will equal zero. |
#3
|
|||
|
|||
Hi
If A1=1, the result could either be 1 or 0.5. I haven't figured out how I am going to deal with this yet, but the formula you gave me works great. Thank you Michael! "Michael" wrote: Hi What happens when A1 =1 ?? I have allowed for this in the formula below by having A1 <= to 1 Put this in B1 =IF(A11,A1-1,IF(A1<=1,0,"")) HTH Michael "sabretooth54" wrote: trying to create this formula: if a1 is greater than 1 then b1 will equal a1 minus 1 and if a1 equals less than 1 then b1 will equal zero. |
#4
|
|||
|
|||
Keep in mind that you can use up to 7 IF statements.
If you post what you want A1=1 to do, I'm sure there will be plenty of solutions And thank you for the feedback HTH Michael "sabretooth54" wrote: Hi If A1=1, the result could either be 1 or 0.5. I haven't figured out how I am going to deal with this yet, but the formula you gave me works great. Thank you Michael! "Michael" wrote: Hi What happens when A1 =1 ?? I have allowed for this in the formula below by having A1 <= to 1 Put this in B1 =IF(A11,A1-1,IF(A1<=1,0,"")) HTH Michael "sabretooth54" wrote: trying to create this formula: if a1 is greater than 1 then b1 will equal a1 minus 1 and if a1 equals less than 1 then b1 will equal zero. |
#5
|
|||
|
|||
Not sure, but would this work?
=MAX(A1-1,0) -- Dana DeLouis Win XP & Office 2003 "sabretooth54" wrote in message ... Hi If A1=1, the result could either be 1 or 0.5. I haven't figured out how I am going to deal with this yet, but the formula you gave me works great. Thank you Michael! "Michael" wrote: Hi What happens when A1 =1 ?? I have allowed for this in the formula below by having A1 <= to 1 Put this in B1 =IF(A11,A1-1,IF(A1<=1,0,"")) HTH Michael "sabretooth54" wrote: trying to create this formula: if a1 is greater than 1 then b1 will equal a1 minus 1 and if a1 equals less than 1 then b1 will equal zero. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula in an Excel comment | Excel Discussion (Misc queries) | |||
Excel should have a simpler subtraction formula similar to "sum". | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |