Array or list

Nsdqdu · May 4th, 2002, 06:17 PM

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 · May 4th, 2002, 06:27 PM

=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 · May 4th, 2002, 06:28 PM

Nimrod · May 4th, 2002, 06:31 PM

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 · May 4th, 2002, 06:32 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 4th, 2002, 06:17 PM	#1
Nsdqdu New Member Join Date: May 2002 Location: Georgia Posts: 8	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 ]

May 4th, 2002, 06:27 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=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

May 4th, 2002, 06:28 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259

May 4th, 2002, 06:31 PM	#4
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	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 ]

May 4th, 2002, 06:32 PM	#5
Nsdqdu New Member Join Date: May 2002 Location: Georgia Posts: 8	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.