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

1. ## 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. ## 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)

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. ## 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. ## 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. ## Re: Formula that goes from multiplication to plus at a set value

happy to help

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

#### 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