=IF(C6=8224,243,IF(C6=8239,248,IF(C6=8228,247,IF(C6=8241,260,IF(C6=8242,281,IF(C6=8245,270,IF(C6=8252,354,IF(C6=8261,288,))))))))
I am trying to assign values based on model numbers. This formula works fine, but it won't let me add anymore than 8.
I still need to add about 15 more model numbers any help would be great.
thanks
Bookmarks