IF AND Statement

[mike]

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!

[Niek Otten]

=IF(AND(A1="N",B1<0),"YES","NO or whatever you want")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"mike" <mike@discussions.microsoft.com> wrote in message
news:86A2A7FC-7ABA-49A8-9403-F3593B3C8446@microsoft.com...
> 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!

[Alan Perkins]

One way:

=IF(AND(A1=N,B1<0),"YES","")

HTH

Alan P

"mike" <mike@discussions.microsoft.com> wrote in message
news:86A2A7FC-7ABA-49A8-9403-F3593B3C8446@microsoft.com...
> 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!