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.
