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)))