Range: Column I2:I2000
My formula in Column H: =IF(I2="DM","Credit","System")
The formula is working fine with a single criteria, being €œDM€� (Returning
€œCredit€� if TRUE or "System" if FALSE)

I am trying to use multiple criteria in this formula: €œDM€�,€�EF€�,€�LM€�,€�ME€�,€�NK€�
i.e.: =IF(I2=€œDM€�,€�EF€�,€�LM€�,€�ME€�,€�NK€ �,Credit","System")
Result: Formula error

Is there another formula that I can use?

EricB