Multiplication & divide with a minimum & maximum return

**allend5** · 10-02-2013, 07:09 AM

Untitled.png

The calculation that I am trying to get excel to calculate in principal is very easy, however, no matter how many combinations of formula that I try I can not seem to get it to work. I want excel to take the gross annual income figure and carry out the following calculations: 70% of the first £10,000, 50% of the next £50,000 and 40% of anything over £60,000. Please help.

**bebo021999** · 10-02-2013, 07:45 AM

For the first 10,000:
=10000*0.7*($A$1>=10000) (or =MIN($A$1,10000)*0.7, depends on your way of calculation for amount less than 10,000)
for next 50,000:
=MAX(MIN(50000,$A$1-10000)*0.5,0)
last
=MAX(0,$A$1-60000)*0.4
Hope it works.

**allend5** · 10-02-2013, 08:11 AM

That is spot on works perfectly, Thank you.

**Fotis1991** · 10-02-2013, 08:29 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED",as per our Forum Rule #9. I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.