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! |
=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! |
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! |
All times are GMT +1. The time now is 10:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com