I need an Excel formula.

Question

I need a formula that will calculate a percentage of a number up to one million and then calculate a different percentage for any amount over that one million.&nbsp; For example:&nbsp; 1,500,000 is the number.&nbsp; I need the first million calculated at 3.5% and then the 500,000 on top of the million calculated at 3.75 percent.&nbsp; The sum to be in one cell when calculated.&nbsp; Thank you.

preagan · Answer

Hello&nbsp;BrMurphy,&nbsp;That could be as follows:=IF(A1-1000000&gt;0,1000000*0.035+(A1-1000000)*0.0375,A1*0.035)

sergeibaklan · Answer

BrMurphy&nbsp;
As variant
=MIN(A1,1000000)*0.35+MAX(0,A1-1000000)*0.375

Forum Discussion

I need an Excel formula.

2 Replies

Resources