Sorry, Duke.....I thought I clicked on the EricB's post. : \

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

=IF(OR(I2={"DM","EF","LM","ME","NK"}),"Credit","Sy stem")


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Duke Carey" wrote:

=IF(OR(I2=€œDM€�,I2=€�EF€�,I2=€�LM€�,I2=€�M E€�,I2=€�NK€�),Credit","System")


"EricB" wrote:

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