IF function

[Guest]

The "IF" function allows for up to seven nested values, what would I use if I
needed more options

The example below has 6 values, once again, what would I use if I needed 10
values?

Example:
=IF(D1650=22,"Upper Ottawa",IF(D1650=23,"Upper Gage",IF(D1650=24,"Upper
Sherman",IF(D1650=25,"Upper Wentworth",IF(D1650=26,"Upper
Wellington",IF(D1650=27,"Upper James",""))))))

 

[Guest]

for situations like you have below you could use something like
=choose(d1650-21,"Upper Ottawa","Upper Gage","Upper

Sherman","Upper Wentworth","Upper
Wellington")

and continue up to 29 items in the choose.

a Vlookup could have been used by seting your options in different columns.

in other words there are nomally work arounds to the different limits.