Forum Discussion
Solved
Choosing hourly rate tables in Excel to calculate fee budgets
Hopefully someone can help with this challenge! I have a client that I work for which we have two sets of hourly rates depending on the location of the work. I have an excel sheet that I trac...
=IF(C2=1,B2*VLOOKUP(B2,$F$3:$G$10,2,FALSE),B2*VLOOKUP(B2,$I$3:$J$10,2,FALSE))
This formula could return the intended result in the sample sheet.
=IF(E3=1,(F3*H14)+(G3*H15),IF(E3=2,(F3*H18)+(G3*H19)))
This works in my sheet. I've made a small change with one closing bracket.
fabulous, thanks!
What a fab community!
What a fab community!