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
Bookmarks