+ Reply to Thread
Results 1 to 4 of 4

multply cells by certain % based on progressive amounts

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    40

    multply cells by certain % based on progressive amounts

    I have a totals column that I am wanting to multiply by various % amounts based on progressive totals... < 30,000 multiply by .20.... >= 30,000 x .35.. etc..

    i.e.

    column A column B

    5000 5000 x .20
    10000 10000 x .20
    15000 15000 x .35 .................. total 30,000



    I currently have the following formula...


    =IF(AND([difference]>0([difference]<=150000),[@Difference]*0.35, IF(AND([@Difference]>150000,[@Difference]<=250000),[@Difference]*0.4, IF(AND([@Difference]>250000,[@Difference]<=350000),[@Difference]*0.45, IF([@Difference]>350000,[@Difference]*0.5,""))))

    any help would be appreciated

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: multply cells by certain % based on progressive amounts

    You don't need to test for the range each time - if your first test is for <=15000 then if that is not met the second test will be on a value that you know will be >15000, so you can do this:

    =IF([@Difference]<=150000,0.35, IF([@Difference]<=250000,0.4, IF([@Difference]<=350000,0.45,0.5)))*[@Difference]

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    07-08-2014
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    40

    Re: multply cells by certain % based on progressive amounts

    Pete,
    Thanks... do you know I can fix the main issue here... multiple the cells with adding progressively

  4. #4
    Registered User
    Join Date
    07-08-2014
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    40

    Re: multply cells by certain % based on progressive amounts

    Pete, Nevermind.. Thanks for your help!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-07-2014, 06:19 PM
  2. [SOLVED] Add Invoice Amounts and Paid Amounts based on user inputs.
    By s2jrchoi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2013, 01:49 PM
  3. Copy cells by multply condition
    By ccsmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2010, 03:02 PM
  4. Progressive Sum Based on Variable.
    By robert_shindorf in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-26-2009, 06:40 PM

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