Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF function
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","")))))) |
#2
|
|||
|
|||
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. "Tuesfutu" wrote: 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","")))))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |