Cell Returns a specific value based on a valiue in another cell

[aSquared]

Hi all

I hope my Title makes sense hehe.

Ok I've been trying to crack my head over this and can't seem to figure out how.

I've attached a sample.

In column A, I have input the IF formula so that each cell in that column will return a value based on the value in Column F in same row.

Example A2 will return the value "OK" if F2 reads "Fault Found"
A5 will return "NA instead because "Unlocalized Fault" is not inside the IF statement requirement.

But the IF statement only allow me to return two values in the pretense of TRUE or FALSE.

I need the cells in column A to return another value, "INVALID" if the cells in column F is either empty or contains other characters such as a dash.

But with the IF function that I'm using, its returning "NA" instead which is not my requirement.

Is there a way to do this using functions?

Any help would be great.

[etaf]

you can nest IFs - try
=IF(OR(F2="Fault Found", F2="No Fault Found"), "OK", IF(OR(F2="", F2="-"),"INVALID","NA") )

what are the other characters ?
are the characters only going to be 1 character

[aSquared]

This works out well. Thanks!

[AZ-XL]

Hi
Another alternative can be like that
=IF(ISERROR(SEARCH("Fault Found",F2)),"NA","OK")

[etaf]

your welcome , thanks for letting us know

If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved