Is this possible...

**tdk595** · 01-19-2012, 01:31 PM

hey everybody,

Im hoping somebody might be willing to tell me how I would go about doing this calculation with excel.

What Im trying to do is:

Make a formula that will calculate 40% of 0-4000, 45% of 4001-8000, and 50% of 8000+.

so if a cell equals 11000 this formula will take

40% of the first 4000
45% of 4001 - 8000
50% of the remaining 3000.

any help would really be appreciated.

Thanks in advance !!!!

**Andrew-R** · 01-19-2012, 01:38 PM

If your value is in cell A1 then in a.n.other cell put:

=MIN(4000*0.4,A1*0.4)+MAX(0,MIN(0.45*(A1-4000),0.45*4000))+MAX(0,0.5*(A1-8000))

**tdk595** · 01-19-2012, 01:53 PM

Great! Thanks for your help!

**royUK** · 01-19-2012, 03:09 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

**royUK** · 01-19-2012, 03:10 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POSTYour post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save