MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Formula Crisis

Posted by Ron Berger on June 08, 2001 9:58 AM

I need a simple formula that checks for 2 conditions.
EX: IF (A1=True AND B1=True, then C1=Yes)

Posted by IML on June 08, 2001 10:07 AM

In C1, try the following:

If you are using a non-reversed word (ie not true, false, etc, put quotes around it.

Good luck.