And function

  • Thread starter Thread starter prpaster
  • Start date Start date
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
 
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
 
By enclosing it in an IF function, you can get any result you want, even text,
i.e.

=IF(A1=B1,"The same","Different)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Gaming Laptop Recommendations Please? 1
Time Count Down 2
Text Help 1
Array problem, I think.. 3
How do I copy a check box result from Worksheet A to Worksheet B? 2
Count function 3
mmb- fiscal year calculation-- 2
Excel Lookup Functions 1

Back
Top