P prpaster Jul 28, 2004 #1 Is there anyway to get an and function to show a number instead of tru and false or is that just what it does Thanks Pau
Is there anyway to get an and function to show a number instead of tru and false or is that just what it does Thanks Pau
K Kostis Vezerides Jul 28, 2004 #2 Hi Paul, The AND() function returns true/false. Numerically, true==1 and false==0. If you *want* 1/0 instead of true/false, you must enclose it in an IF(). =IF(AND(......), 1, 0) HTH Kostis Vezerides
Hi Paul, The AND() function returns true/false. Numerically, true==1 and false==0. If you *want* 1/0 instead of true/false, you must enclose it in an IF(). =IF(AND(......), 1, 0) HTH Kostis Vezerides
M Myrna Larson Jul 28, 2004 #3 By enclosing it in an IF function, you can get any result you want, even text, i.e. =IF(A1=B1,"The same","Different)
By enclosing it in an IF function, you can get any result you want, even text, i.e. =IF(A1=B1,"The same","Different)
