VBA Express Forum
>
VBA Code & Other Help
>
Excel Help
> IF Formula
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)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.