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

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

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

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

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

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

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