Hello, I have attached a document I need help with:
Basically I need the DEDUCTION ($) column to display the result I am after based on the information shown below the table.
It’s kind of hard to describe my question, considering I’m not sure what formula I should use to achieve the intended result. Hopefully the information supplied in the attached document should make everything self- explanatory.
I’m not trying to be lazy here, it’s just that the formula required to work out the result I need is a bit advanced for me as I only just started using calc.
Could anyone who is good at using calc please assess the attached document and explain the formula I need to use here? I would be extremely grateful as I’m a little out of my depth here.