Formula For Multiple Breaks In Calculations

[Homer1818]

I need help in creating a formula that will calculate different percentages
based on numbers at different levels and if there is no number in the cell,
show the cell were the results would go as blank or a dash. It also need to
take in consideration that each break to the next level and precentage will
occur within a number. When that happens that number would then need to be
divided based based on the two different percentages using the following
conditions:

Up to 1,000,000.00 calculated at 2%
From 1,000,000.01 to 2,500,000.00 calculated at 3%
From 2,500,000.01 to 5,000,000.00 calculated at 4%
From 5,000,000.00 and higher calculated at 5%

Each percentage calcutation should be shown in its on column.

Any help would be appreicated.

 

[JE McGimpsey]

one way:

A1: <number>
B1: =IF(A1>0,MIN(A1*2%,20000),"")
C1: =IF(A1>1000000,MIN((A1-1000000)*3%,75000),"")
D1: =IF(A1>2500000,MIN((A1-2500000)*4%,100000),"")
E1: =IF(A1>5000000,(A1-5000000)*5%,"")

OTOH, if you want to do it in one cell, see

http://www.mcgimpsey.com/excel/variablerate.html