IF Statement, including AND

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all

I am trying to create an IF statement but am struggling to include the AND
function with it.

How can I say 'if' A1 >= 1000 'and' A2="yes", return one result for true,
and return another result for false? I can Create IF statements but have
never used AND before.

Thank you.
Louise
 
Hi

=AND(A1>=1000,A2="yes")

(No need for IF's, when the result must be boolean)
 
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

Nested If/And/Or statements 4
adding result of "if" statement.. 3
IF Statements 9
need help with if statement that calculate minimum figure 2
Collapsing all groups 0
MATCH not working in IF statement 6
vlookups and if statement 1
Help with IF Statemet 3

Back
Top