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!
|