A
Alex Martinez
Hi,
It's my understanding that I can nest up to seven levels of the IF functions
within one formula. My question is how does one nest over seven levels?
Below is the actual code without adding the additional IF statements.
=IF(D8=" "," ",IF(D8=$L$81 Then
+Insured!$G$38-Worksheets!D45,IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,IF(D8=$L$84,+Insured!$G$44-Worksheets!D45)))))
Here's is an example of over sevel levels where I like to add to the cell,
but again I cannot because Excel only nest up to seven levels.
=IF(D8=" "," ,
IF(D8=$L$81,+Insured!$G$38-Worksheets!D45,
IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,
IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,
IF(D8=$L$84,+Insured!$G$44-Worksheets!D45,
IF(D8=$L$85,+Insured!$G$46-Worksheets!D45,
IF(D8=$L$86,+Insured!$G$48-Worksheets!D45,
IF(D8=$L$87,+Insured!$G$50-Worksheets!D45,
IF(D8=$L$88,+Insured!$G$52-Worksheets!D45,
IF(D8=$L$89,+Insured!$G$54-Worksheets!D45,
IF(D8=$L$90,+Insured!$G$56-Worksheets!D45)))))))))))
Any tips will be appreciated. Thank you.
It's my understanding that I can nest up to seven levels of the IF functions
within one formula. My question is how does one nest over seven levels?
Below is the actual code without adding the additional IF statements.
=IF(D8=" "," ",IF(D8=$L$81 Then
+Insured!$G$38-Worksheets!D45,IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,IF(D8=$L$84,+Insured!$G$44-Worksheets!D45)))))
Here's is an example of over sevel levels where I like to add to the cell,
but again I cannot because Excel only nest up to seven levels.
=IF(D8=" "," ,
IF(D8=$L$81,+Insured!$G$38-Worksheets!D45,
IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,
IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,
IF(D8=$L$84,+Insured!$G$44-Worksheets!D45,
IF(D8=$L$85,+Insured!$G$46-Worksheets!D45,
IF(D8=$L$86,+Insured!$G$48-Worksheets!D45,
IF(D8=$L$87,+Insured!$G$50-Worksheets!D45,
IF(D8=$L$88,+Insured!$G$52-Worksheets!D45,
IF(D8=$L$89,+Insured!$G$54-Worksheets!D45,
IF(D8=$L$90,+Insured!$G$56-Worksheets!D45)))))))))))
Any tips will be appreciated. Thank you.