And function

[prpaster]

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

 

[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

 

[Myrna Larson]

By enclosing it in an IF function, you can get any result you want, even text,
i.e.

=IF(A1=B1,"The same","Different)