MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need 3 qualifiers to return "true" in this formula...=IF(OR(('Green-Red'!G31='Green-Red'!G$20),(IS

Posted by Greg on January 23, 2002 9:06 PM

I need to add a third qualifier to this statement and just cannot seem to get it to work. Any help appreciated...


I need to also add a qualifier ro this formula that will also return true (1) if "G29" is equal to 0 (that's a zero).


Posted by anno on January 23, 2002 11:19 PM

this worked for me: =IF(OR(('Green-Red'!G31='Green-Red'!G$20),ISBLANK('Green-Red'!G31),G29=0),1,0)

Posted by Aladin Akyurek on January 24, 2002 5:55 AM


> greg
> this worked for me: =IF(OR(('Green-Red'!G31='Green-Red'!G$20),ISBLANK('Green-Red'!G31),G29=0),1,0)
> : )