PDA

View Full Version : IF Formula



pico
11-20-2006, 09:18 AM
Is there an "and" operator i could use with the IF formula in excel?
ex: if (case1 and case2 is true then output True else false)

austenr
11-20-2006, 09:42 AM
=IF(A2=1,IF(B2=2,1,0)) :hi:

In this case 1 is the "True" and 0 is the "False"

Bob Phillips
11-20-2006, 09:47 AM
=IF(AND(A1=1,B1=2),TRUE,FALSE)

or if you really want TRUE/FALSE

=AND(A1=1,B1=2)