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...

=IF(OR(('Green-Red'!G31='Green-Red'!G$20),(ISBLANK('Green-Red'!G31))),1,0)

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

Thanks
Greg


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

greg
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

Equally...

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

=OR('Green-Red'!G31='Green-Red'!G20,LEN('Green-Red'!G31)=0,G29=0)+0

========