+ Reply to Thread
Results 1 to 6 of 6

varying a dollar amount with a percentage

  1. #1
    Registered User
    Join Date
    05-24-2007
    Posts
    73

    varying a dollar amount with a percentage

    Kind of stuck here:

    I want the user to input in cell C16 a dollar amount. If the dollar amount is less than $125 the output in cell C17 should show 35%, between $125 and $299 the output should be 22%, over $299 the output should be 17%

    Can someone help me out? Thanks!

  2. #2
    Registered User
    Join Date
    05-24-2007
    Posts
    73
    also to throw in a twist. Within each of those above categories I would like for every variation of $10 the percentage to go up or down accordingly 1%

  3. #3
    Registered User
    Join Date
    05-24-2007
    Posts
    73
    any and all guidance would be GREATLY appreciated

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Within each of those above categories I would like for every variation of $10 the percentage to go up or down accordingly 1%
    ???

    If 22% at $125, 21% at $135, ... then at $295 it's 5%, and then increases to 17% at $299?

    For your original question, =LOOKUP(C16, {0,125,299}, {0.35,0.22,0.17})
    Last edited by shg; 04-29-2008 at 07:41 PM.

  5. #5
    Registered User
    Join Date
    05-24-2007
    Posts
    73
    thanks, i realize the math doesnt work out now, but once i have the correct formula i can play around with the numbers. Thanks for the base equation but if you know how to integrate the variation within the category that would be terrific

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    You can add all the breakpoints and rates that you wish to the previous formula.

+ Reply to Thread

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