help with excel formula... 1

[allcarfan]

need to combine these statements into one If/then, not, AND statement


If cell E3 is blank and N3 is blank, then blank
If Cell E3 is not blank and N3 is blank, then "open"
If cell E3 is not blank and N3 is not blank, then "closed"

Im frying my brain with IFs, IFNOTs, NOTs, ANDs and I cannot get this to work.

 

[combo]

=IF(AND(E3<>"",N3<>""),"closed",IF(E3<>"","open",""))

Returns blank if E3 is empty and N3 not empty.

combo

 

[allcarfan]

Hell yeah! Thank yoU!!!

 

[SkipVought]

allcarfan,

Over the past 8 years you have posted many questions and received many helpful replies from Tek-Tip members. Yet, you have NEVER posted a customary "THANK YOU" for these valuable posts.

Since you replied, "Hell yeah! Thank yoU!!!" to combo, it would be most fitting to...

[blue]
Thank PHV
for this valuable post![/blue]

These [purple]Little Purple Stars[/purple] identify threads for Tek-Tips browsers, as ones that have been helpful. They also act as a token "Thank You" to the one or ones who posted valuable information. And they identify the recipient as a grateful member.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[randy700]

It would be even MORE FITTING to

[blue]Thank [red]combo[/red]
for this valuable post![/blue]


Randy

 

[SkipVought]

oops.

the perils of copy 'n' paste 'n' ignore

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]