tax payroll calculation

February 24, 2011 at 00:49:57
Specs: Windows XP
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 manually

Please help

Thank you


See More: tax payroll calculation

Report •

February 24, 2011 at 14:28:07
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.

Report •

February 24, 2011 at 14:31:27
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.

Report •

Related Solutions

Ask Question