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)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Louise" wrote in message
...
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

Try =IF(AND(A1=100,A2="yes")"one result", "other result")
Beege

"Louise" wrote in message
...
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

=IF(AND(A1=1000,A2="yes"),True Result, False Result)

"Louise" wrote:

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

that's great, thank you.
Louise

"Paul Mathews" wrote:

=IF(AND(A1=1000,A2="yes"),True Result, False Result)

"Louise" wrote:

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 Louise,

=IF(AND(A11000,A2="yes"),"Match","xx")

~Jess

"Louise" wrote:

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