Hi,
I an trying to solve this nesting but cant. Below is the formula that tried to use but gives me the error for too much nests. Below the formula is the table with the values. I tried a VLOOKUp but didnt work, probably I was doing it wrong.
=IF(AND($D$4="AA",I7=1),10,IF(AND($D$4="AA",I7=2),18,
IF(AND($D$4="AA",I7=3),38,IF(AND($D$4="AA",I7=4),51,
IF(AND($D$4="BB",I7=1),10,IF(AND($D$4="BB",I7=2),27,
IF(AND($D$4="BB",I7=3),38,IF(AND($D$4="BB",I7=3),46,
IF(AND($D$4="CC",I7=1),10,IF(AND($D$4="CC",I7=2),0,
IF(AND($D$4="CC",I7=3),35,IF(AND($D$4="CC",I7=4),51,
IF(AND($D$4="DD",I7=1),10,IF(AND($D$4="DD",I7=2),25,
IF(AND($D$4="DD",I7=3),55,IF(AND($D$4="DD",I7=4),0))))))))))))))))
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]TYPE[/TD]
[TD]AA[/TD]
[TD]BB[/TD]
[TD]CC[/TD]
[TD]DD[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]18[/TD]
[TD]27[/TD]
[TD]0[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]38[/TD]
[TD]38[/TD]
[TD]35[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]51[/TD]
[TD]46[/TD]
[TD]51[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
I an trying to solve this nesting but cant. Below is the formula that tried to use but gives me the error for too much nests. Below the formula is the table with the values. I tried a VLOOKUp but didnt work, probably I was doing it wrong.
=IF(AND($D$4="AA",I7=1),10,IF(AND($D$4="AA",I7=2),18,
IF(AND($D$4="AA",I7=3),38,IF(AND($D$4="AA",I7=4),51,
IF(AND($D$4="BB",I7=1),10,IF(AND($D$4="BB",I7=2),27,
IF(AND($D$4="BB",I7=3),38,IF(AND($D$4="BB",I7=3),46,
IF(AND($D$4="CC",I7=1),10,IF(AND($D$4="CC",I7=2),0,
IF(AND($D$4="CC",I7=3),35,IF(AND($D$4="CC",I7=4),51,
IF(AND($D$4="DD",I7=1),10,IF(AND($D$4="DD",I7=2),25,
IF(AND($D$4="DD",I7=3),55,IF(AND($D$4="DD",I7=4),0))))))))))))))))
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]TYPE[/TD]
[TD]AA[/TD]
[TD]BB[/TD]
[TD]CC[/TD]
[TD]DD[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]18[/TD]
[TD]27[/TD]
[TD]0[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]38[/TD]
[TD]38[/TD]
[TD]35[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]51[/TD]
[TD]46[/TD]
[TD]51[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]