| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple ifs and formulas
I need help building a formula for this:
if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
hi
try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
I think you meant
=IF(A124,B1*0.9,IF(A10,B1*0.7,"")) or perhaps =IF(A129,"",IF(A124,B1*0.9,IF(A10,B1*0.7,""))) .... and the OP may wish to think about what result is required for A1 less than zero, between 24 and 25, or beyond 29. .... and also whether "between" is inclusive or not. -- David Biddulph "FSt1" wrote in message ... hi try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
Okay that helps, but it's also a bit more complex because there are 11 tiers:
0-24 is .07 25-29 multiply by .09 30-34 multiply by .12 35-39 multiply by .13 40-44 multiply by .15 45-49 multiply by .22 50-54 multiply by .34 55-59 multiply by .63 60-64 multiply by .97 65-69 multiply by 1.87 70-99 multiply by 3.04 Is this still possible? And the range includes the beginning and ending number. Cell A1 is always a positive and is below 99. Thank you!!! "David Biddulph" wrote: I think you meant =IF(A124,B1*0.9,IF(A10,B1*0.7,"")) or perhaps =IF(A129,"",IF(A124,B1*0.9,IF(A10,B1*0.7,""))) .... and the OP may wish to think about what result is required for A1 less than zero, between 24 and 25, or beyond 29. .... and also whether "between" is inclusive or not. -- David Biddulph "FSt1" wrote in message ... hi try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
Try this
=B1*VLOOKUP(A1,{0,0.07;25,0.09;30,0.12;35,0.13;40, 0.15;45,0.22;50,0.34;55,0.63;60,0.97;65,1.87;70,3. 04},2) -- Regards, Peo Sjoblom "NeSchw6G" wrote in message ... Okay that helps, but it's also a bit more complex because there are 11 tiers: 0-24 is .07 25-29 multiply by .09 30-34 multiply by .12 35-39 multiply by .13 40-44 multiply by .15 45-49 multiply by .22 50-54 multiply by .34 55-59 multiply by .63 60-64 multiply by .97 65-69 multiply by 1.87 70-99 multiply by 3.04 Is this still possible? And the range includes the beginning and ending number. Cell A1 is always a positive and is below 99. Thank you!!! "David Biddulph" wrote: I think you meant =IF(A124,B1*0.9,IF(A10,B1*0.7,"")) or perhaps =IF(A129,"",IF(A124,B1*0.9,IF(A10,B1*0.7,""))) .... and the OP may wish to think about what result is required for A1 less than zero, between 24 and 25, or beyond 29. .... and also whether "between" is inclusive or not. -- David Biddulph "FSt1" wrote in message ... hi try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
It's always better if you ask the whole question to start with, to avoid
wasting your time and ours by providing an answer to a different question. Peo has given an answer to your revised question, but you still haven't said what you want for an input value between 24 and 25, or between 29 and 30, or between 34 and 25. If your input is guaranteed to be an integer, then say so. In Excel, as in so many things, finding the answer is relatively easy; finding the question seems to be the hard part. -- David Biddulph "NeSchw6G" wrote in message ... Okay that helps, but it's also a bit more complex because there are 11 tiers: 0-24 is .07 25-29 multiply by .09 30-34 multiply by .12 35-39 multiply by .13 40-44 multiply by .15 45-49 multiply by .22 50-54 multiply by .34 55-59 multiply by .63 60-64 multiply by .97 65-69 multiply by 1.87 70-99 multiply by 3.04 Is this still possible? And the range includes the beginning and ending number. Cell A1 is always a positive and is below 99. Thank you!!! "David Biddulph" wrote: I think you meant =IF(A124,B1*0.9,IF(A10,B1*0.7,"")) or perhaps =IF(A129,"",IF(A124,B1*0.9,IF(A10,B1*0.7,""))) .... and the OP may wish to think about what result is required for A1 less than zero, between 24 and 25, or beyond 29. .... and also whether "between" is inclusive or not. -- David Biddulph "FSt1" wrote in message ... hi try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple ifs and formulas
I didn't even spot that
-- Regards, Peo Sjoblom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... It's always better if you ask the whole question to start with, to avoid wasting your time and ours by providing an answer to a different question. Peo has given an answer to your revised question, but you still haven't said what you want for an input value between 24 and 25, or between 29 and 30, or between 34 and 25. If your input is guaranteed to be an integer, then say so. In Excel, as in so many things, finding the answer is relatively easy; finding the question seems to be the hard part. -- David Biddulph "NeSchw6G" wrote in message ... Okay that helps, but it's also a bit more complex because there are 11 tiers: 0-24 is .07 25-29 multiply by .09 30-34 multiply by .12 35-39 multiply by .13 40-44 multiply by .15 45-49 multiply by .22 50-54 multiply by .34 55-59 multiply by .63 60-64 multiply by .97 65-69 multiply by 1.87 70-99 multiply by 3.04 Is this still possible? And the range includes the beginning and ending number. Cell A1 is always a positive and is below 99. Thank you!!! "David Biddulph" wrote: I think you meant =IF(A124,B1*0.9,IF(A10,B1*0.7,"")) or perhaps =IF(A129,"",IF(A124,B1*0.9,IF(A10,B1*0.7,""))) .... and the OP may wish to think about what result is required for A1 less than zero, between 24 and 25, or beyond 29. .... and also whether "between" is inclusive or not. -- David Biddulph "FSt1" wrote in message ... hi try this... =IF(A124,A1*0.9,IF(A10,A1*0.7,"")) regards FSt1 "NeSchw6G" wrote: I need help building a formula for this: if cell A1 is between 0-24 then multiply cell B1 by .07 and if cell A1 is between 25-29 then mulitply cell B1 by .09 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple formats in a single cell with multiple formulas | Excel Worksheet Functions | |||
| Formulas with multiple IFs | Excel Worksheet Functions | |||
| Multiple AND/OR formulas | Excel Discussion (Misc queries) | |||
| Sort multiple columns with multiple formulas without returning #R | Excel Worksheet Functions | |||
| Multiple Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
