» Eliminating Errors Resulting from If Functions with Multiple Conditions
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem:The following formula returns FALSE, even though both conditions are true (i.e. cell A2=5 and cell B2=8):
=IF(A2=5&B2=8,TRUE,FALSE)
Solution:
Use the IF and AND functions as shown in the following formula:
=IF(AND(A2=5,B2=8),TRUE,FALSE)
Book Store:
No comments have been submitted.
