Array or list

[Nsdqdu]

I cannot get this formula to work:
IF(G9="H""K""L""M""N""O""P",H8-E9,H8)))

If G9 has any of those letters I want it to perform the h8-h9 formula. I have tried a bunch of stuff and I am even using the "excel 2002 formulas" book by Walkenbach. I don't get an error, it will only recognize if I have 1 letter in the arguement. I tried using brackets around the group of letters as well.
This message was edited by Nsdqdu on 2002-05-04 17:17
This message was edited by Nsdqdu on 2002-05-04 17:18

 

[Aladin Akyurek]

=IF(OR(G9={"H","K","L","M","N","O","P"}),H8-E9,H8)


Alternatively:

=H8-(ISNUMBER(MATCH(G9,{"H","K","L","M","N","O","P"},0)))*E9

Aladin

 

[Nimrod]

[No message]

 

[Nimrod]

IF((OR(G9="H",G9="K",G9="L",G9="M",G9="N",G9="O",G9="P"),H8-E9,H8))
This message was edited by Nimrod on 2002-05-04 17:32

 

[Nsdqdu]

THANK YOU!!!!!!!! Aladin. I'm not the best at syntax, I was close but still far away. I misused the OR function. You just alieviated a lot of stress from my life.