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(AND(A1=TRUE,B1=TRUE),"yes","")

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

Good luck.