Maths question....

L

landlord

Registered User
Messages
1,068
I am trying to work out a formulae for a spreadsheet.

When ECB rates are 1.5% my tax bill is approx 7,000 Euro
...........................1.25% ..........................8,000 Euro
............................1.00%..........................9,000 Euro etc....
how can i express this in a mathmatical formulae...so I can quickly work out my tax based on rising and falling ECB rates....I.e. all I have to do is plug in the new ECB rate and it calculates my tax.
thanks in advance......
 
landlord said:
I am trying to work out a formulae for a spreadsheet.

When ECB rates are 1.5% my tax bill is approx 7,000 Euro
...........................1.25% ..........................8,000 Euro
............................1.00%..........................9,000 Euro etc....
how can i express this in a mathmatical formulae...so I can quickly work out my tax based on rising and falling ECB rates....I.e. all I have to do is plug in the new ECB rate and it calculates my tax.
thanks in advance......
Click to expand...

Clearly, you are omitting a few details about how your tax is actually calculated. If you enter the calculation formula and hit F4 on your keyboard when you point at the box where the ECB rate is held, that should always use whatever is held in that box, which you change as the ECB rate changes. For example, if your tax is X times the marginal rate minus the ECB rate then the formula might be as follows;
Tax = A$2$ -A$1$ [where A$2$ is the marginal tax rate and A1 is the box on the spreadsheet where you enter the ECB rate - use F4 to set these so they work for all lines after that.]
 
ClubMan said:
But, apropos of Slim's comments above, are you sure that that makes sense and takes into account all relevant info/details?
Click to expand...

the tax part of this is greatly simplified and not important. This was more of a maths question and understanding how to work out excell formulae....Incidentally Excell changed the formulae to make it work for some reason to...
=SUM(13000-((I35/0.25*1000)))

where I35 = the ECB rate.
 
I don't understand given that your tax bill is dependent on a lot of factors how you can be sure that this is a correct formula, especially given by the fact you state
When ECB rates are 1.5% my tax bill is approx 7,000 Euro

Oh OK, you qualified it by your last answer. bit of a roundabout way to ask how excel formulas work. I guess next time I should stick to my rules of not answering any questions that have a vague title.
 
You must log in or register to reply here.
Back
Top