Nesting IF's and AND's - a bit of help please...
 

Hi. I have 3 formula's which I would like merging into one?

=IF(AND(C3<$B$1,C31/1/1,D3=""),"N","")

=IF(AND(C3$B$1,D3=""),"M","")

=IF(AND(C31/1/1,D31/1/1),"Y","")

I would like all these as one formula in cell E3?

I've had a try myself but am not very good at nesting functions....

Thanks in advance.

Nesting IF's and AND's - a bit of help please...
 

I think you've confused everyone with this expression:

1/1/1

As it's written in your formula, it evaluates to:

1 divided by 1 divided by 1

Which equals 1.

Is that really what you had in mind?

--
Biff
Microsoft Excel MVP


"neilcarden" wrote in message
...

Hi. I have 3 formula's which I would like merging into one?

=IF(AND(C3<$B$1,C31/1/1,D3=""),"N","")

=IF(AND(C3$B$1,D3=""),"M","")

=IF(AND(C31/1/1,D31/1/1),"Y","")

I would like all these as one formula in cell E3?

I've had a try myself but am not very good at nesting functions....

Thanks in advance.




--
neilcarden

Nesting IF's and AND's - a bit of help please...
 

Hi,
Try this:
=IF(AND(C3<$B$1,C31/1/1,D3=""),"N",IF(AND(C3$B$1,D3=""),"M",IF(AND(C31/1/1,D31/1/1),"Y","")))


"neilcarden" wrote:


Hi. I have 3 formula's which I would like merging into one?

=IF(AND(C3<$B$1,C31/1/1,D3=""),"N","")

=IF(AND(C3$B$1,D3=""),"M","")

=IF(AND(C31/1/1,D31/1/1),"Y","")

I would like all these as one formula in cell E3?

I've had a try myself but am not very good at nesting functions....

Thanks in advance.




--
neilcarden