Results 1 to 4 of 4

More than 7 if statments

Threaded View

  1. #1
    Registered User
    Join Date
    01-24-2008
    Posts
    2

    More than 7 if statments

    =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
    Last edited by VBA Noob; 01-24-2008 at 05:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1