And function

P

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
 
K

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

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

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