| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nested IF AND OR function Inexplicable error
I have the following formula which I believe does not breach any rules, yet
it returns an error message. Can anyone see where my error is? I would much appreciate any help, and thank you in advance. I don't believe I am breaching the max 7 arguments rule. =if(OR (AND(J44="GreenAbove",J43="GreenAbove",J42="RedBel ow"), AND(J44="GreenAbove",J43="GreenBelow",J42="RedBelo w"), AND(J44="GreenBelow",J43="GreenBelow",J42="GreenBe low",J41="RedBelow")), C44,"") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| undefined function error when creating xls pivot from mdb qry | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Lookup Function Error | Excel Worksheet Functions | |||
Threaded Mode
