Log in

View Full Version : [SOLVED:] 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)