"FALSE" When using IF with INDEX & MATCH

[bfuentes1412]

Hello,

I can't seem to get this formula to work. It will work if the initial statement "true" but if false it won't execute the second statement. The value in F6 should will be determined by the value in D6 OR E6. Only one value will be used, with D6 being the primary. The Calc should be: If the value in D6>0, D6 will be multiplied by a value in L6:L10 based on the matching value between B6, and K6:K10. If the value in D6 is <0 then the value of F6 will be determined by, E6 multiplied by B6, multiplied by a value in L6:L10 based on the matching value between B6, and K6:K10.

Thank you for your help!

fast charger calc.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
4
5		PF	QTY	KW	KVA	KW				VOLTAGE	QTY	DF
6		0.73	9 - 12		22	FALSE				120	1 -4	1
7										208	5 - 8	0.92
8										240	9 - 12	0.87
9										480	13 - 16	0.83
10											17 - 28	0.81
11
Sheet1

Cell Formulas
Range	Formula
F6	F6	=IF(D6>0,D6*(INDEX(L6:L10,MATCH(C6,K6:K10),E6*B6*(INDEX(L6:L10,MATCH(C6,K6:K10))))))

Cells with Data Validation
Cell	Allow	Criteria
C6	List	=$K$6:$K$10

 

[MARK858]

Do you mean...

=IF(D6>0,D6*(INDEX(L6:L10,MATCH(C6,K6:K10))),E6*B6*(INDEX(L6:L10,MATCH(C6,K6:K10))))

 

[bfuentes1412]

Do you mean...

=IF(D6>0,D6*(INDEX(L6:L10,MATCH(C6,K6:K10))),E6*B6*(INDEX(L6:L10,MATCH(C6,K6:K10))))
[/CODE
[/QUOTE]

 

[bfuentes1412]

Ugh! Thanks Mark!! That did it.

 

[smozgur]

Thanks Mark!! That did it.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[MARK858]

Ugh! Thanks Mark!! That did it.

You're welcome