formula help
Posted by Jeannette on January 24, 2002 10:21 AM
I am trying to figure workers comp. I know the numbers are not realistic...
This tax is calculated at $3.77 per $1000 of the projected annual salary.. The salary is 26850.00
How can I get this in to a formula
Posted by gregc on January 24, 2002 10:30 AM
(salary/1000)*3.77
Posted by Mark W. on January 24, 2002 10:30 AM
If I understand your inquiry the formula would
be =3.77*TRUNC(A1/1000) where cell A1 contains
26,850. Is 98.02 the desired result?
Posted by Jeannette on January 24, 2002 10:40 AM
Didn't work!!!
ok.. before I can put in that part of the formula I have another part added. This part is a must...
=if(right(a3)+0=1
This is saying if this person is salary than I need to do the workers comp..
So when I put what you gave me after this.. like
=if(right(a3) +0=1, 3.77 *TRUNC (N3/1000)
This doesn't work...I get an error.. #name
Posted by Barrie Davidson on January 24, 2002 12:50 PM
Re: Didn't work!!!
=if(right(a3)+0=1 This is saying if this person is salary than I need to do the workers comp.. So when I put what you gave me after this.. like
Add an bracket to your formula. It should read
=if(right(a3)+0=1, 3.77*TRUNC (N3/1000))
BarrieBarrie Davidson
