IF Statement, including AND
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
|