+ Reply to Thread
Results 1 to 6 of 6

Formula that goes from multiplication to plus at a set value

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    Keflavik, Iceland
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Question Formula that goes from multiplication to plus at a set value

    Hi, this is my first post here at Excelforum.com, sorry for my english if it's not completely correct, not my native language

    I'm trying to figure out a formula that can switch from multiplication to plus at a set value

    f.e. A * B * C , but when the sum for A*B goes up to 10.000, then it switches to A * B + 2.500

    Is it possible to have a formula that does this by itself ?

    I hope you understand what I'm trying to say

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Formula that goes from multiplication to plus at a set value

    Hi, welcome to the forum

    Not sure what is in C, so this is untested, but perhaps something like...

    =IF(A1*B1>10,A1*B1+2.5,A1*B1*C1)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-19-2014
    Location
    Keflavik, Iceland
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Re: Formula that goes from multiplication to plus at a set value

    Here is en example of what i'm thinking

    A: 230
    B: 45

    230*45 = 10350, since it's greater then 10000, then I'd just like to add 2500 to the sum for A*B = 12850

    but if the sum is lower then 10000, then I'd want to multiply it with 25%, or 1.25 f.e. 9500 * 1,25 = 11875

    so
    <10000 = A*B*1.25
    >10000 = A*B+2500

    It's for a list to calculate the price for fuel, so the fuel price can be changing, and I spend a lot of time changing the formula, and I am wondering if there is a formula i could use, that calculates it automatically

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Formula that goes from multiplication to plus at a set value

    Did you try my formula? (obviously with the adjusted values from your last post...
    =IF(A1*B1>10000,A1*B1+2500,A1*B1*1.25)
    or...
    =IF(A1*B1>10000,A1*B1+2500,A1*B1*(1+C1))
    A
    B
    C
    D
    1
    230
    40
    0.25
    11500
    2
    230
    45
    0.25
    12850

  5. #5
    Registered User
    Join Date
    11-19-2014
    Location
    Keflavik, Iceland
    MS-Off Ver
    MS Office 2007
    Posts
    3

    Re: Formula that goes from multiplication to plus at a set value

    That's exactly what I was looking for, thanks for your help

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,898

    Re: Formula that goes from multiplication to plus at a set value

    happy to 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. [SOLVED] VBA Multiplication Formula
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2013, 04:32 AM
  2. What formula to use the multiplication
    By macroashraf in forum Excel General
    Replies: 5
    Last Post: 05-24-2012, 10:36 AM
  3. multiplication formula in excel
    By v.muruganandam in forum Excel General
    Replies: 2
    Last Post: 07-25-2009, 01:30 AM
  4. multiplication formula error
    By ZOHAR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2007, 02:10 PM
  5. Multiplication formula
    By yuvosh in forum Excel General
    Replies: 5
    Last Post: 03-05-2007, 08:05 AM

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