IF function

T

Tuesfutu

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",""))))))
 
B

bj

for situations like you have below you could use something like
=choose(d1650-21,"Upper Ottawa","Upper Gage","Upper
Sherman","Upper Wentworth","Upper
Wellington")
Click to expand...
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.
 
Top