With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, April 13, 2017
yogi_Compute Rate Of Pay Based On Position and Years
I want to figure out the rate of pay for an employee based on the position and the number of years worked. The first sheet has the employee's position and the number of years worked. The second sheet has a list of positions and the rate of pay based on the number of years worked.
I have tried a variety of formulas with no luck. I am able to do the lookup based on the position but don't know how to get the rate of pay based on the number of years worked. Any help would be appreciated.