Hi guys,
I have the below formula that works beautifully for me. The user enters a step number into P93 (step being 1 thru 5) and A93 returns a monthly salary rate by looking up on the data tab the job description the user selects in A91. FYI, A89 is the department name.
On the data tab, I have multiple lists of departments and the job titles for each department and each job title has a monthly salary for each of the 5 steps.
But i need it to show the hourly rate. So, the monthly salary needs to be multiplied by 12 and then divided by 2080 and I can't seem to figure out where to put that extra math in the below.
Any help is appreciated, thanks!
=IF(P93="","",INDEX(OFFSET(INDIRECT(A89&"JOBS"),0,P93),MATCH(A91,INDIRECT(A89&"JOBS"),0)))
Bookmarks