olimajor123
Board Regular
- Joined
- Nov 13, 2013
- Messages
- 72
Hi there
Please see the attached sample - I'm looking for some help with a formula.
Location - https://www.dropbox.com/s/x1b80aj5hm3fmfb/Sample.xls?dl=0
On the 'Valuation Sheet' I want the Call Out Charge column P to auto fill with the cost of the call out which is determined by the type of work (Column M), the Time of Day completed (Column L) and the priority of the call out (Column N). Depending on these values the call out charge should enter based on the table on the SLA's and Values sheet as this displays the cost dependant on the scenario.
I think this would be an IFS forumla with a V Look Up though I am not sure. If anyone could assist with the formula I would be grateful.
Thanks
Please see the attached sample - I'm looking for some help with a formula.
Location - https://www.dropbox.com/s/x1b80aj5hm3fmfb/Sample.xls?dl=0
On the 'Valuation Sheet' I want the Call Out Charge column P to auto fill with the cost of the call out which is determined by the type of work (Column M), the Time of Day completed (Column L) and the priority of the call out (Column N). Depending on these values the call out charge should enter based on the table on the SLA's and Values sheet as this displays the cost dependant on the scenario.
I think this would be an IFS forumla with a V Look Up though I am not sure. If anyone could assist with the formula I would be grateful.
Thanks
