Error message with formula IF

[perdiz4u]

Dear all,

Kindly help me with the below issue.

When i try to use the following formula, always receive the error "the specified formula cannot be entered because it uses more levels of nesting than are allowed"

The formula is:

IF(LEFT(E9,1) = "1", "Spain", IF(LEFT(E9,1) = "2", "Spain", IF(LEFT(E9,1) = "3", "Spain", IF(LEFT(E9,1) = "4", "Spain", IF(LEFT(E9,1) = "5", "Spain", IF(LEFT(E9,1) = "6", "Spain", IF(LEFT(E9,1) = "7", "Spain", IF(LEFT(E9,1) = "8", "Spain", IF(LEFT(E9,1) = "9", "Spain", IF(LEFT(E9,1) = "2", "Spain"))))))))))

Thanks,
Ibrahim

[jeffreybrown]

Your profile shows 2007, but that error message would indicate 2003. 2007+ does not have the limit of 7 nested IFs.

I guess the big question, what are you trying to do?

[FDibbins]

Hi and welcome to the forum

Im not sure what you are trying to do, but your formula can be simplified to this...

=IF(and(value(LEFT(E9,1))>0,value(LEFT(E9,1))<10),"Spain","")