Results 1 to 4 of 4

How to simplify this formula?

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2008
    Posts
    87

    How to simplify this formula?

    Hello there,

    Is there a way to simplify this If Statement forumla?

    Basically I have a dropdown list that selects form the range: C21-C34 then in E21-E34 I have prices that change per line item. This If Statement is working, but it's long and cumbersome. Plus if I ever need to add any line items it won't work. Is there a way to use sumproduct or something else that will look at the dropdown list in C39 and pull from the appropriate match in C21-C34 and list the price in Column E in same row?

    =IF(C39=C21,E21,IF(C39=C22,E22,IF(C39=C23,E23,IF(C39=C24,E24,IF(C39=C25,E25,IF(C39=C26,E26,IF(C39=C27,E27,IF(C39=C28,E28))))
    I have posted my example as well.

    Thanks,
    Lorne
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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