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