i need help making a monthly payroll calculation which changes based on monthly exchange rate

the gross amount is 7500nis and the tax is calculated on $ basis

600 $ is 0 tax

833 $ is 5%

and the rest is 10 %

i cannot find a formula that will do this calculation manuallyPlease help

Thank you

Jacquelinem

You could use a lookup field based on the dollar amount and then make the calculations. I would fix a cell to hold the monthly exchange rate - you could change the exchange rate and not have to alter a constant in the formula by using the cell reference for the exchange rate.

So, you enter the dollar amount, which looks up the percentage for the next cell, uses the exchange rate and delivers the calculation to the cell you desire.

If I am not understanding your need, please comment further.

I'm still learning everyday.

You could use an if greater than and if less than type of formula and a calculate ... if cell > 600 and cell <= 800 then cell2 * tax else if cell > 833 then cell2 * tax

Use the "if then" formulas.

I would still put the exchange rate in one location so that you use a reference. :)

I'm still learning everyday.

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History