| 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. |
| 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) | |||
Threaded Mode
