Thread: IF function
View Single Post
  #1   Report Post  
Tuesfutu
 
Posts: n/a
Default 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",""))))))