Ask Your Question

Help using an advanced calc formula

asked 2017-01-27 19:37:52 +0200

appreciatethehelp gravatar image

updated 2017-01-27 19:40:09 +0200

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

C:\fakepath\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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-01-29 01:32:12 +0200

m.a.riosv gravatar image

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


image description

edit flag offensive delete link more

answered 2017-01-27 20:10:57 +0200

JohnHa gravatar image

updated 2017-01-29 17:30:42 +0200

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-27 19:37:52 +0200

Seen: 100 times

Last updated: Jan 29 '17