Dec 14 2021 04:21 PM
Hi,
Need help with building a formula. I'm creating an easy to use estimating workbook for my company and need a formula for returning a manhour rate based on when the work is to be performed i.e normal hours, overtime, weekend or public holiday for a selected trade.
So I have three columns, Trade, Rate Type, Rate Value. User will choose the trade and rate type and based on these choices the formula should return the rate value.
Really appreciate any help.
Dec 14 2021 04:58 PM
Dec 14 2021 05:07 PM