Home |
Search |
Today's Posts |
#1
|
|||
|
|||
if/then statement that results in Yes/No
I want either a Yes or No given this if/then statement:
If cell A1 is greater than x AND cell B1 is greater than Y, then YES otherwise NO. AND, the sum of A1+B1 must be greater than z. All conditions must be met. How do I do this? Thanks. -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Hi
=AND(A1x,B1y,A1+B1z) -- Arvi Laanemets ( My real mail address: arvil<attarkon.ee ) "Patty via OfficeKB.com" wrote in message ... I want either a Yes or No given this if/then statement: If cell A1 is greater than x AND cell B1 is greater than Y, then YES otherwise NO. AND, the sum of A1+B1 must be greater than z. All conditions must be met. How do I do this? Thanks. -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
=if(and(A1x,B1y,A1+B1z),"Yes","NO")
"Patty via OfficeKB.com" wrote: I want either a Yes or No given this if/then statement: If cell A1 is greater than x AND cell B1 is greater than Y, then YES otherwise NO. AND, the sum of A1+B1 must be greater than z. All conditions must be met. How do I do this? Thanks. -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
Thanks. How do I get a YES/NO to appear instead of a true/false?
Arvi Laanemets wrote: Hi =AND(A1x,B1y,A1+B1z) I want either a Yes or No given this if/then statement: [quoted text clipped - 3 lines] Thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200508/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Subtotaling on column with IF statement results | Excel Discussion (Misc queries) | |||
IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
If/Then statement | Excel Discussion (Misc queries) | |||
adding if statement results | Excel Worksheet Functions |