# Conditional formula

#### atmicmu

##### New Member
I need some help

(don't worry about the dutch words, not important for the question)

So I'm making a sheet that can keep my income and costs every month and calculate my taxes etc automaticly.
Fot taxes and other stuff in Belgium we use a system based on net income according to the following table;

 Belastingschijf Inkomensschijf Tarief belasting Schijf 1 € 0 tot €12 990 25% Schijf 2 € 12 990,01 t/m € 22 290 40% Schijf 3 € 22 290,01 t/m € 39 660 45% Schijf 4 Meer dan 39 660,01 euro 50%

<tbody style="box-sizing: border-box;">
</tbody>

So, what I can't find is how to formulate in 1 cell that the % tax has to be according to this table?

Thanks for helping!

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### wideboydixon

##### Well-known Member
Not sure how this converts to Dutch format formula but here's what I'd do:

Maybe it's:

Code:
``=VLOOKUP(\$A2,{0\0.25;12990,01\0.4;22290,01\0.45;39660,01\0.5},2,TRUE)``

WBD

#### atmicmu

##### New Member
Thank you WBD!

I think I understand where you are going with this. What I need is the following;

When my total income minus costs = X
And the calculation you make is Y

How do i: Create 1 cell that automaticly looks at X and decides what % to use (Y) to give me a total that is (gros-taxes=net)

#### wideboydixon

##### Well-known Member
I guess that would be column D:

WBD

Replies
0
Views
163
Replies
3
Views
419

1,109,341
Messages
5,528,146
Members
409,802
Latest member
joeino

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...