calculating social security formula

[Guest]

I need help with a formula for calcuating social security taxes. The
calculation is based upon 6.2 of the annual salary, and the calculation stop
at a 90,000.00.
so if the salary is 100K, you do not calculate past the first 90K


Thanks much

 

[John Vinson]

I need help with a formula for calcuating social security taxes. The
calculation is based upon 6.2 of the annual salary, and the calculation stop
at a 90,000.00.
so if the salary is 100K, you do not calculate past the first 90K


Thanks much

0.062 * CCur(IIF([Salary] > 90000, 90000, [Salary]))

You may also want to use Round() to round the result to the nearest
penny (or dollar as appropriate).

John W. Vinson[MVP]

 

[Guest]

use iif function
iif(salary < 90000,salary,90000)

 

[Guest]

Perfect - thank you very much

I need help with a formula for calcuating social security taxes. The
calculation is based upon 6.2 of the annual salary, and the calculation stop
at a 90,000.00.
so if the salary is 100K, you do not calculate past the first 90K


Thanks much

0.062 * CCur(IIF([Salary] > 90000, 90000, [Salary]))

You may also want to use Round() to round the result to the nearest
penny (or dollar as appropriate).

John W. Vinson[MVP]

 

[Guest]

Thank you very much.

use iif function
iif(salary < 90000,salary,90000)