Help using an advanced calc formula

[appreciatethehelp]

Hello, I have attached a document I need help with:

Benefit deduction example.ods

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.

[JohnHa]

See Chapter 7 in the Calc manual - all is explained there.

There are many ways. One way is to use one or more IF statements. ie IF (X) Then (Y) Else Z.

So, If salary greater than 100 and less than 200, THEN reduction equal (salary - 100) * 0.3 Else reduction = 0

If salary greater than 300, reduction equals $30 + (salary - 300) * 0.7

[mariosv]

Perhaps something like this it’s what you are looking for.

148554239973229.ods