IF statement with 3 possible outcomes

 

I am struggling with an if and statement.

I have 3 possible outcomes (B1000, B2000, B3000) based on certain critera.

Want answer in column A, based on info in colum B&C.

Column B has codes in starting with S or Z (folllowed by series of numbers).

Column C will be either blank or have a number in it.

The 3 results I need are:

“B1000” if column B starts with either S or Z but column C is blank

“B2000” if column B starts with an S and column C has a number

“B3000” if column B starts with a Z and column C has a number

 

By: Tom

Leave a Reply

Your email address will not be published. Required fields are marked *