| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF(AND(etc., etc. ... problem
Hello fellow helpers,
I have created the following equation: =IF(AND(N10="Large",O10<500),"Incorrectly Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized"))) And it works, however inelegantly, for the first set of conditions. For the second and third set it just gives a value of false. I have tried scrunching up the conditions, and only having one "if true" statement at the end, but this syntax didn't work either. Please send help soon. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(AND(etc., etc. ... problem
Nicole,
=IF(AND(N10="Large",O10<500),"Incorrectly Categorized",IF(AND(N10="Medium",OR(O10500,O10<80 )),"Incorrectly Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized","OK"))) HTH, Bernie MS Excel MVP "Nicole Seibert" wrote in message ... Hello fellow helpers, I have created the following equation: =IF(AND(N10="Large",O10<500),"Incorrectly Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized"))) And it works, however inelegantly, for the first set of conditions. For the second and third set it just gives a value of false. I have tried scrunching up the conditions, and only having one "if true" statement at the end, but this syntax didn't work either. Please send help soon. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF(AND(etc., etc. ... problem
Hi
Use this way: =IF(AND(N10="Large",O10500),"Incorrectly Categorized",IF(AND(N10="Medium",O1080,O10<=500), "Incorrectly Categorized",IF(AND(N10="Small",O10=80),"Incorrec tly Categorized"))) "Nicole Seibert" wrote: Hello fellow helpers, I have created the following equation: =IF(AND(N10="Large",O10<500),"Incorrectly Categorized",IF(AND(N10="Medium",O10500,O10<80)," Incorrectly Categorized",IF(AND(N10="Small",O1080),"Incorrect ly Categorized"))) And it works, however inelegantly, for the first set of conditions. For the second and third set it just gives a value of false. I have tried scrunching up the conditions, and only having one "if true" statement at the end, but this syntax didn't work either. Please send help soon. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| have some problem with database | Excel Discussion (Misc queries) | |||
| Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
