We have employee dept, rank and hours worked data on a spreadsheet similar to below:
what's not included in the spreadsheet is rate per hour. What I want to do is create a new column that calculates the total $ for the work.
my thinking (pls correct me if im wrong) is that an if then might work here? i dont know if its possible to have multiple if-then statements in a cell.
if department = construction and rank = manager, then hours worked * 50
else if department = design and rank = manager then hours worked *40
and so on
does this make sense? i am open to any other options for solution!
It's better to add range with rates at any place of your workbook as
and use formula