WHAT FORMULA DO I USE? I want to use Microsoft Excel to answer the the following equation:?

Question

5.25% of initial 25
3.25% of remaining

for 5 values 5, 10, 20, 50, 150

so i want it to figure out whether or not each value is more than 25 if it is i want it to calculate 5.25% of 25 and 3.25% of remaining value

Answers should be:

5 = 0.2625
10 = 0.525
20 = 1.05
50 = 2.125
150 = 5.375

i would just like to enter ANY value, not necessarily one of the 5 given values, (i.e. "50") and see results (i.e. "2.125"). i would like to enter any number value i want excel to calculate the rest. thanks in advance.

Answer 1

The following formula should do the trick. Assuming your data starts in A1 and goes down in col. A, then in B1 enter:

=(0.0525*MIN(A1,25))+
(MAX(0.0325*(A1-25),0))

The formula is entered on two lines here to display properly. Copy and paste it to cell B1 and get rid of the line break.

After you've entered the formula, copy and paste in cell B2 down col. B through the end of your data in col. A.

If you think about how the MIN and MAX functions work, you will understand why this does what you want (check help on the MIN and MAX functions if you are unfamiliar with them).

Answer 2

=IF(G2>G3,G2*5.25%,"Less then 25") where G2 is the number you want to test, and G3 is the limit (ie, 25 in this case)

This will display 5.25% of G2 if it is over G3, and will display "Less than 25" if not.

Then

=B4*3.25%

Where B4 is the cell that the first equation is located in

This will multiply the value, if any, by 3.25%

That should do ya.