# Multiply by Two Different Percentages based on Different Amounts

#### heattrader

##### New Member
I need a formula that looks at a cell and multiplies a percentage in another cell.

For Example: If the number in cell E14 is less than or equal to 5,000,000 then multiply cell F17 (which is 55%) - This formula is in cell E17. The next formula needs to be in cell E18, If the number in cell E14 is greater than 5,000,000 then multiply cell F18 (which is 45%). So, the formulas are looking at one cell and if the number is less than or equal to 5,000,000, then multiply by 55%, if the number is greater than 5,000,000, then multiply by 45%. So, the formula has to be able to only multiply 55% up to 5,000,000 and the other formula needs to multiply by 45% over 5,000,000.

Thank for your help!

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### Andrew Poulsom

##### MrExcel MVP
Welcome to Mr Excel.

Try:

E17 =IF(E14<=5000000,E14*F17,"")
E18 =IF(E14>5000000,E14*F18,"")

#### heattrader

##### New Member
These formulas work, but I need E17 to give me an answer on the first 5,000,000 and E18 gives the answer on everything over 5,000,000. So, if E14 equals 15,000,000, then E17 would equal 2,750,000 (55% of 5M) and E18 would equal 4,500,000 (45% of 10M) . I probably did not explain this clearly enough in my original post.

#### Andrew Poulsom

##### MrExcel MVP
That would be:

=IF(E14>5000000,(E14-5000000)*F18,"")

#### heattrader

##### New Member
That would be:

=IF(E14>5000000,(E14-5000000)*F18,"")

I got it to work with:

E17 = IF(E14>=5000000,5000000*F17,E14*F17)
E18 = IF(E14>5000000,(E14-5000000)*F18,"")

Replies
4
Views
162
Replies
3
Views
77
Replies
5
Views
322
Replies
2
Views
101
Replies
2
Views
289

Threads
1,127,426
Messages
5,624,734
Members
416,046
Latest member
Elliottj2121

### Share this page ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?    ### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back