Multiple-Value formulas

[EricB]

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

 

[Duke Carey]

=IF(OR(I2=“DMâ€,I2=â€EFâ€,I2=â€LMâ€,I2=â€MEâ€,I2=â€NKâ€),Credit","System")

 

[Arvi Laanemets]

Hi

=IF(ISNA(MATCH(I2,{"DM";"EF";"LM";"ME";"NK"},0)),"System","Credit")

 

[Ron Coderre]

Try this:

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


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

XL2002, WinXP

 

[Ron Coderre]

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

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

XL2002, WinXP

 

[EricB]

Hi Ron

Great, working 100%

Much appreciated

EricB
=================

 

[Ron Coderre]

I'm glad I could help......Thanks for the feedback.


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

XL2002, WinXP