Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement, including AND
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement, including AND
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement, including AND
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement, including AND
=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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement, including AND
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement including BETWEEN | Excel Worksheet Functions | |||
reconcile two months statement? | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |