If a Cell has "Yes" or "NA" do nothing

[seansr]

I have a big tracking spreadsheet that adds new lines to the top and copy cells but collegues keep deleting a cell because it wasn't right on the previous row

I have this Formula =IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"), "check with Barry", "")

However in M9 there is NA which is returning check with Barry
If M9 has Yes The cell is empty

How can I change the formula to be empty if M9 contains Yes or NA but still show check with Barry if M9 is empty

 

[ETAF]

is it NA or the error #N/A

you can use an OR() within an AND()

something like

=IF( OR( M9="yes",M9="NA) , "", IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"), "check with Barry", "")

what are ALL the rules for "check with Barry"

you can have

AND( condition1, condition2 , OR( condition3, condition4)

so condition Must be
condition1 AND condition2 AND condition3
OR
condition1 AND condition2 AND condition4

 

[seansr]

That's Brilliant
The Rules are:-
if we receive some information: M should be updated from Blank to Yes (however sometimes this is not applicable hence NA)
If yes and now NA then The formula in N shows nothing
If M is blank and the date of installation (P) is within 7 days then N shows Check with Barry ( the person who can chase this up from Treasury)

This is now what I have
=IF(OR(M9="yes",M9="NA"),"",IF(AND(P9<>"",P9<=$B$3+7,M9<>"Yes"),"check with Barry",""))
Brilliant thanks for your help, much appreciated

 

[ETAF]

you are welcome,, glad its working ok