+ Reply to Thread
Results 1 to 9 of 9

Drop-down list connected to multiple formulas

Hybrid View

  1. #1
    Registered User
    Join Date
    12-16-2011
    Location
    Alliance, NE
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Drop-down list connected to multiple formulas

    This is very close to what I want, but I don't want multiple lists. I want to be able to select an item from the drop down list then have a the numerical formulas in each column to the right change based on my list selection.

    For example:

    A1 will have a fertilizer grade of 10-34-0 which would be from a list. A2 will be where I insert a number. A3 will be =A2*0.1. A4 will be =A2*0.34.

    If I chose 32-0-0 from A1, then A3 would be =A2*0.32.

  2. #2
    Registered User
    Join Date
    12-16-2011
    Location
    Alliance, NE
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Drop-down list connected to multiple formulas

    The list would have about 8 entries at the most. Each column will have 5 formulas at the most. However, depending on the selection from the list, some columns won't use a formula everytime as they will just need to equal zero.

+ Reply to Thread

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