User Profile
prcrispxl185
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
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 track projects with that I use to understand fees for different levels of input and there is an easy calculation being used of agreeing the budget for a project - so 3 hours of person x at y rate - to give an overall fee budget. However, if I were to add in a changing rate, so there is a column which says whether rate table 1 or 2 is applicable. The fee calculation then needs to change on the basis of which rate table is referred to - so its an IF? command? Does this make sense?Solved1.5KViews0likes5Comments
Groups
Recent Blog Articles
No content to show