IF conditional statements

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.
 
C

CLR

The VLOOKUP function is the common solution to the "need more than seven
nested IF's" problem.............

Vaya con Dios,
Chuck, CABGx3
 
A

Arvi Laanemets

Hi

=IF(D8="","",OFFSET(Insured!$G$38,2*(MATCH(D8,$L$81:$L$90,0)-1),0)-Worksheets!D45)
 
Top