kingkhan786
New Member
- Joined
- Sep 11, 2014
- Messages
- 8
Hello,
Sheet 1 is my main summary sheet which has details , rate being charged, total amount etc.
Sheet 2 is Car rates
Sheet 3 is Truck Rates
Within tabs 2 and 3 - there's a table which has a set of prices depending on vehicle type, day/night prices, priority, bank holiday/sunday rates.
Below in Bold are my columns on my main summary (sheet 1).
Date / Type of work / Site Address / Date Work Required / Details of Work Needed / Priority / Contact Name / Number / Worker/ Vehicle / Time Started / Time Finished / Hours Worked / Rate (£) / Total Amount (£)
On my main screen, I want to enter a formula into the 'Rate' column and I want the relevant rate to appear. This will be determined on the vehicle type (if it's car or truck), then whether it's a day or night rate, and the priority.
Any advice on what formula I should use? By the way, I'm fairly new to excel.
Sheet 1 is my main summary sheet which has details , rate being charged, total amount etc.
Sheet 2 is Car rates
Sheet 3 is Truck Rates
Within tabs 2 and 3 - there's a table which has a set of prices depending on vehicle type, day/night prices, priority, bank holiday/sunday rates.
Below in Bold are my columns on my main summary (sheet 1).
Date / Type of work / Site Address / Date Work Required / Details of Work Needed / Priority / Contact Name / Number / Worker/ Vehicle / Time Started / Time Finished / Hours Worked / Rate (£) / Total Amount (£)
On my main screen, I want to enter a formula into the 'Rate' column and I want the relevant rate to appear. This will be determined on the vehicle type (if it's car or truck), then whether it's a day or night rate, and the priority.
Any advice on what formula I should use? By the way, I'm fairly new to excel.
