Excel returns wrong value?

[thomexcel]

=IF(K3=1;12;IF(K3=2;10;IF(K3=3;8;IF(K3=4;7;IF(K3=5;6;IF(K3=6;5;IF(K3=7;4;IF(K3=8;3;IF(K3=9;2;IF(K3=10;1)+IF(O3=1;12;IF(O3=2;10;IF(O3=3;8;IF(O3=4;7;IF(O3=5;6;IF(O3=6;5;IF(O3=7;4;IF(O3=8;3;IF(O3=9;2;IF(O3=10;1)))))))))))))))))))

In K3 the value is 1, and in O3 it's also 1. But then formula return 12, why not 24?

[JBeaucaire]

You've nested the O part inside the K section, so it only triggers when K=9.

1) create you K an O formulas separately in different cells. Make sure they are working independently. THEN merge them into a single formula with a + in between.

[JBeaucaire]

Another approach, switch to a lookup table:

Data Range

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Lookup	Return
2	1	12
3	2	10									1				1	12	=VLOOKUP(K3, $A$2:$B$11, 2, 0)
4	3	8														12	=VLOOKUP(O3, $A$2:$B$11, 2, 0)
5	4	7														24	=VLOOKUP(K3,$A$2:$B$11,2,0)+VLOOKUP(O3,$A$2:$B$11,2,0)
6	5	6
7	6	5
8	7	4
9	8	3
10	9	2
11	10	1
12
13

This is easy to edit, and you can put this lookup table on a separate sheet, of course.

[thomexcel]

Thanks I figured it out

[JBeaucaire]

See post #4.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.