Formula to Add Text based on Series

Nicole Forleades

Hello,

I am trying to find a formula that will allow me use the series column and then return text in the approved column.

EX: if series is B, or L I want the Approver column to return RSM. If the Series column is S or K want the approver to be CE. I have hit a brick wall in figuring this out.

Melissa Yamada

Hello @Nicole Forleades

Try:

=IF(OR(Series@row="B",Series@row="L"),"RSM",IF(OR(Series@row="S",Series@row="K"),"CE"))