If, Then, and, or Statement

[weaselmcguff]

Not sure if this is possible but looking for suggestions.

Column M is a Purchase Order field which has either a Number or the word Lost in it
Column N is Out for Calibration field which has values of YES, No, Lost
Column L is a Notes field

I want column L and N to be populated by the results from Column M

If Column M = a Number then I want Column L to say "Out for Calibration" and Column N = Yes
If Column M = "Lost" then I want Column L to say " Lost - Cannot Locate" and Column N = Lost
If Column M = Blank then I want Column L to say "N/A" and Column N = No

Can this be done?

Thanks for your assitance

 

[Joe4]

For a value in cell M1:

Place this formula in cell L1:

=IF(ISNUMBER(M1),"Out for Calibraton",IF(M1="Lost","Lost - Cannot Locate",IF(M1="","N/A","")))

Place this formula in cell N1:

=IF(ISNUMBER(M1),"Yes",IF(M1="Lost","Lost",IF(M1="","No","")))

 

[weaselmcguff]

Thanks works like a champ.

was missing the last if statement when i was working on it.

 

[Joe4]

You are welcome.
Glad I was able to help!