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
Bookmarks