![]() |
|
|
|
#1
|
|||
|
|||
|
I'll just go ahead and answer this, since I found someone who fixed it -- in case it helps someone. First off, it should be noted that the ab, cd, etc. are placeholders and not actual strings. Second, for some strange reason the "general" format sometimes makes it difficult to operate on logical expressions. Who knows why, but the OR() vars needed no quotes, and the others did...go figure.
I've definitely become a Mac user over the last few years, but this is one area where #%*! Apple. So much of Excel's developer stuff is missing or not as good. Hope this helps another iPerson. |
|
| Tags |
| boolean, if function, nested |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Nested IF
|
TDWolsey | Excel | 2 | 01-06-2016 11:31 PM |
| nested if and averageA | windseaker | Excel | 0 | 08-14-2015 04:13 PM |
using if and nested vlookup
|
wentworth16238 | Excel | 5 | 06-14-2015 12:59 PM |
| Nested Vlookup Help | asluder2000 | Excel | 2 | 11-14-2014 11:00 PM |
Nested IFs
|
JimS378 | Excel | 7 | 05-03-2011 08:20 PM |