Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Calculating different tax levels

Featured Replies

  • Newbies

I would very much appreciate help with trying to work this out. I’m trying to develop a number of databases using Filemaker Pro 9 Adv for a ministry in Kosovo.

One aspect that I’m trying to automate for budget and personnel purposes is to show deductions on salaries for income tax.

It works like this:

There are four levels.

After a gross salary there is a deduction for pension contributions (that I’ve worked out it’s a simple calculation and I have a field to capture the result).

After that there are the income tax deductions.

These are for the first 80 euros the rate is 0

From 80.01 to 250 it is 5%

From 250.01 to 450 – 10%

Above 450 - 20%

For info these are monthly figures

My question is can I use an IF or CASE function using the calculated result field that I have as mentioned, that would in effect find the different ranges within the number, and if so what would the formula be. I’ve looked around for a solution and have been racking my not terribly mathematical brain and thus far, have not come up with the solution.

Any advice would be extremely valued

Thanks

John

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.