Formula not working
 

This formula doesn't work:
=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't fit
into any of the other IF statements.

What have I done wrong? Connie

Formula not working
 

Try this instead:

=IF(I43<=10,"0-10",IF(I43<=20,"11-20",IF(I43<=35,"21-35",IF(I43<=49,"36-49","50+"))))

In your formula, 0-10 is treated as Zero minus Ten, not Zero through Ten.

HTH,
Elkar


"Connie Martin" wrote:

This formula doesn't work:
=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't fit
into any of the other IF statements.

What have I done wrong? Connie

Formula not working
 

Try this version

=LOOKUP(J43,{0,11,21,36,50},{"0-10","11-20","21-35","36-49","50+"})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Connie Martin" wrote in message
...
This formula doesn't work:

=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"
36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't
fit
into any of the other IF statements.

What have I done wrong? Connie

Formula not working
 

Thank you. That works! I guess I think more mathematically in Excel!!
Connie

"Elkar" wrote:

Try this instead:

=IF(I43<=10,"0-10",IF(I43<=20,"11-20",IF(I43<=35,"21-35",IF(I43<=49,"36-49","50+"))))

In your formula, 0-10 is treated as Zero minus Ten, not Zero through Ten.

HTH,
Elkar


"Connie Martin" wrote:

This formula doesn't work:
=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't fit
into any of the other IF statements.

What have I done wrong? Connie

Formula not working
 

Thank you. That works, too! Connie

"Bob Phillips" wrote:

Try this version

=LOOKUP(J43,{0,11,21,36,50},{"0-10","11-20","21-35","36-49","50+"})

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Connie Martin" wrote in message
...
This formula doesn't work:

=IF(I43=0-10,"0-10",IF(I43=11-20,"11-20",IF(I43=21-35,"21-35",IF(I43=36-49,"
36-49","50+"))))

In I43 the number is 41, therefore in I44, where I have this formula, it
should be giving 36-49, not 50+. It should only give 50+ when it doesn't
fit
into any of the other IF statements.

What have I done wrong? Connie