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