Advanced nested if with several conditions

[Lucerobrima]

https://docs.google.com/spreadsheets/d/16usEk9KrUYyuaZImKxybGZaiLzWUzk-qegXXrN5r7rc/edit?usp=sharing


<bdo dir="ltr">=IF(OR(C15;D15="";B15*$B$3;IF(B15;D15="";C15*$C$4;IF(B15;C15="";D15*D5;IF(D15="";B15*$B$6+C15*$C$6;IF(B15="";C15*$C$7+D15*$D$7;IF(C15="";B15*$B$8+D15*$D$8;IF(D15="";B15*$B$9+C15*$C$9;IF(B15="";C15*$C$10+D15*$D$10;IF(B15:D15=ISNUMBER;B15*$B$11+C15*$C$11+D15*$D$11))))))))))

This formula is supposed to work with the 9 different scenarios but It doesn´t, you can see the SHEETS in drive to see how does the logic work.
</bdo>

 

[wideboydixon]

Yep. That's ugly. What's the difference between Condition 4 and Condition 7? Also, what's the difference between Condition 5 and Condition 8? They look the same.

Refactoring the order of the conditions makes this much easier:

Book1
	A	B	C	D	E	F
1		Weight of Variable / Ponderacin de la variable
2		Time	Cost	Earnings	Total
3	Condition 1	100.00%	0.00%	0.00%	100.00%
4	Condition 2	0.00%	100.00%	0.00%	100.00%
5	Condition 3	50.00%	50.00%	0.00%	100.00%
6	Condition 4	0.00%	0.00%	100.00%	100.00%
7	Condition 5	50.00%	0.00%	50.00%	100.00%
8	Condition 6	0.00%	50.00%	50.00%	100.00%
9	Condition 7	45.00%	20.00%	35.00%	100.00%
10
11		Variable value / Valor de la variable
12		Time	Cost	Earnings	Global Result
13	Condition 1	0.07			0.07	0,07
14	Condition 2		0.06		0.06	0,06
15	Condition 3			0.08	0.08	0,08
16	Condition 4	0.02	0.02		0.02	0,02
17	Condition 5		0.04	0.04	0.04	0,04
18	Condition 6	0.05		0.05	0.05	0,05
19	Condition7	0.03	0.03		0.03	0,03
20	Condition 8		0.02	0.02	0.02	0,02
21	Condition 9	0.12	0.15	0.16	0.14	0,14
Sheet1

Cell Formulas
Range	Formula
E13	=SUMPRODUCT($B13:$D13,INDEX($B$3:$D$9,--($B13<>"")+2*--($C13<>"")+4*--($D13<>""),))

WBD

 

[Lucerobrima]

I just realized

 

[Lucerobrima]

there is no difference between those conditions, Duplicates, thank you so much that works!