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","")))))) |
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","")))))) |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com