Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
Formula entered not working | Excel Discussion (Misc queries) |