Calculation Problem

Morning Folks,

Looking for a bit of help with a calculation that I can work out most of, but come across a tricky bit I cannt seem to get working whaterver I try.

I've attached a sample for you to have a quick look.

But, I have 3 ranges,

1. 15 or less (C6)

If cell B6 is greater than 15, than I want to show 15, and if less, then show actual value. I have this working fine.

2. 16 to 40 (D6)

If cell value in B6 is less than 15. then ,0,, if greater than 16 but less than 40, then show value from b6 minus C6. And if greater than 40, then only show 40.

3. 41+ (E6)

If cell value if less than 41, then show value but deducting D6 + C6. And if cell value is greater than 41, then show actual value.

Basically, the end result should shouw that C6, D6 & E6 should equate to B6.

I hope this make's sense, as my head is hurting already.

Cheers,

Daywalker

Daywalker,

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.


Given zbor's replies already I won't lock the thread down on this occasion.