Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF AND Statement
Can some please explain how to write a statement that will do the following
A1 has value of N B1 has value of -100 I am wanting to put a formula in C1 that says if A1=N and B1 is less than 0 put a YES in C1. I cannot figure this out. Please Help! |
#2
|
|||
|
|||
=IF(AND(A1="N",B1<0),"YES","NO or whatever you want")
-- Kind Regards, Niek Otten Microsoft MVP - Excel "mike" wrote in message ... Can some please explain how to write a statement that will do the following A1 has value of N B1 has value of -100 I am wanting to put a formula in C1 that says if A1=N and B1 is less than 0 put a YES in C1. I cannot figure this out. Please Help! |
#3
|
|||
|
|||
One way:
=IF(AND(A1=N,B1<0),"YES","") HTH Alan P "mike" wrote in message ... Can some please explain how to write a statement that will do the following A1 has value of N B1 has value of -100 I am wanting to put a formula in C1 that says if A1=N and B1 is less than 0 put a YES in C1. I cannot figure this out. Please Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |