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
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. |
#3
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. |
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) |