Need help with IF AND OR statement please

[Brian6751]

Hello, this is my first post here and i was wondering if i could get some help with this formula. I just cannot get it to work properly.

here is what I have as of now.

=IF(AND(OR(ISBLANK(AT2), A2<>"na")),AD2="Fac Exist"),"na","fac exist w/ proj")

here is what i am trying to do:

IF AD2="Fac Exist"

AND

AT2 is BLANK OR A2 <> "na"

THEN

"na"

IF FALSE

"fac exist w/ proj"



any help is VERY much appreciated!!!

[alansidman]

Try this:

If(and(AD="FAC Exist",or(AT2 = "",A2 <> "na")),"na","fac exist w/proj")

[sweep]

One bracket too many perhaps?

=IF(AND(OR(ISBLANK(AT2), A2<>"na"),AD2="Fac Exist"),"na","fac exist w/ proj")

[Jonmo1]

You've got an extra ) in there..

=IF(AND(OR(ISBLANK(AT2), A2<>"na")),AD2="Fac Exist"),"na","fac exist w/ proj")

Should be
=IF(AND(OR(ISBLANK(AT2), A2<>"na"),AD2="Fac Exist"),"na","fac exist w/ proj")


Also, if AT2 is a formula, and it might return "", ISBLANK will not consider that blank.
Might be better to use
AT2=""
=IF(AND(OR(AT2="", A2<>"na"),AD2="Fac Exist"),"na","fac exist w/ proj")

[klvaughnsd]

=IF(AND(OR(ISBLANK(AT2), A2<>"na")),AD2="Fac Exist"),"na","fac exist w/ proj")

Maybe
=IF(AND(OR(ISBLANK(AT2),A2<>"na"),AD2="Fac Exist"),"na","fac exist w/ proj")

[Brian6751]

wow. thanks for all the quick replies

all of these are returning as "fac exist w/ proj" when AD2 does not equal "Fac Exist". AT2 is BLANK and A2 is "na"

this cell should be returned as "na"

[alansidman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Brian6751]

the formula is in B2. i hope this is sufficient

Sample Workbook.xlsx

[Jonmo1]

all of these are returning as "fac exist w/ proj" when AD2 does not equal "Fac Exist". AT2 is BLANK and A2 is "na"

That's what you said you wanted.

here is what i am trying to do:

IF AD2="Fac Exist"

AND

AT2 is BLANK OR A2 <> "na"

THEN

"na"

IF FALSE

"fac exist w/ proj"

I think you need to re-define your expectations for us.
You have 8 possible combinations of the values in the 3 cells.
Please answer the following

AD2="FAC Exist" and AT2 is blank and A2 = na : I want ??
AD2="FAC Exist" and AT2 is blank and A2 does not = na : I want ??
AD2="FAC Exist" and AT2 is NOT blank and A2 = na : I want ??
AD2="FAC Exist" and AT2 is NOT blank and A2 does not = na : I want ??
AD2 does not = "FAC Exist" and AT2 is blank and A2 = na : I want ??
AD2 does not = "FAC Exist" and AT2 is blank and A2 does not = na : I want ??
AD2 does not = "FAC Exist" and AT2 is NOT blank and A2 = na : I want ??
AD2 does not = "FAC Exist" adn AT2 is NOT blank and A2 does not = na : I want ?

[Brian6751]

i realized column A was no longer needed and this worked:

=IF(AND(NOT(ISBLANK(AT2)),AD2="Fac Exist"),"fac exist w/ proj","na")

Thank you very much!!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.