|
Post by anneinwa on May 15, 2017 15:01:43 GMT
Hoping someone can point me in the right direction if what I want is possible.
I am trying to figure out how to streamline my time when doing timecards each week when it comes to computing Worker's comp.
Currently I use Numbers (Apple) and each line consists of a class code, hours works, employee withholding rate, amount to be withheld, employer contribution rate, and contribution amount. I plug the numbers in to keep it organized/less error, but use a calculator to figure out the amounts to contribute/withhold.
I am guessing the should be a way to set it up so that the program does this for me? If so, is there a way that if I plug in the class code, it would autofill the contribution/withholding rates too?
Anne
|
|
|
Post by ~summer~ on May 15, 2017 15:03:46 GMT
Yes I think you want to use an =iff or =if statement
|
|
|
Post by katlady on May 15, 2017 15:14:36 GMT
Try using lookup tables within your function. I have a report setup where I need to put in the name of the employee. I am fed their employee ID number from a mainframe generated report that I download into excel. I then use lookup tables to fill in the employee's names.
|
|
|
Post by anneinwa on May 15, 2017 15:24:04 GMT
Thanks for this feedback... I know almost squat about tables and these programs but can learn but need a push where to start... Now I have something to search and see where it leads me.
|
|
|
Post by ~summer~ on May 15, 2017 15:37:34 GMT
How many codes are there? If there are a lot you should use vlookup
|
|
|
Post by anneinwa on May 15, 2017 15:48:27 GMT
How many codes are there? If there are a lot you should use vlookup right now 7, but I will probably be adding to bring our cost down.
|
|
|
Post by anneinwa on May 15, 2017 16:08:43 GMT
Try using lookup tables within your function. I have a report setup where I need to put in the name of the employee. I am fed their employee ID number from a mainframe generated report that I download into excel. I then use lookup tables to fill in the employee's names. Adding this to consider second.. we only have one employee so guessing this will be helpful when we hire a second or more?
|
|