Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula For Multiple Breaks In Calculations
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. -- Homer |
#2
|
|||
|
|||
one way:
A1: <number B1: =IF(A10,MIN(A1*2%,20000),"") C1: =IF(A11000000,MIN((A1-1000000)*3%,75000),"") D1: =IF(A12500000,MIN((A1-2500000)*4%,100000),"") E1: =IF(A15000000,(A1-5000000)*5%,"") OTOH, if you want to do it in one cell, see http://www.mcgimpsey.com/excel/variablerate.html In article , Homer1818 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions | |||
Countif Formula with 2 calculations | Excel Discussion (Misc queries) | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |