Rate Calculation
Stefi
Many thanks I had the single formula on the same worksheet. I have the sheet
working with the original formula that you provided.
Once again many thanks for your help.
Regards
Zephyr
"Stefi" wrote:
$307.5 is the correct result, I get the same with the alternative solution!
Please copy here your exact multiplier table with cell references to check it!
Stefi
zephyr ezt *rta:
Stefi
Many thanks to you and the other guys that responded.
With the alternative solution I have put the multipliers in cells B3 to H5
and the formula in cell B6 to H6.
The cells have different totals than the first solution.
i.e. Cell B6 =$307.5 with the first solution
Cell B6 =$108.75 with the single formula
I may have the formula in the wrong cell, I have checked the cell references
and they appear ok. You're help is appreciated
Many thanks
"Stefi" wrote:
Another solution:
Make a helper table of multipliers in Sheet2:
A B C D E F G H
1 Mon Tue Wed Thu Fri Sat Sun
2
3 Normal Hours 1,0 1,0 1,0 1,0 1,0 1,5 2,0
4 Hours x 1.5 1,5 1,5 1,5 1,5 1,5 1,5 2,0
5 Hours x 2 2,0 2,0 2,0 2,0 2,0 1,5 2,0
You need only a single formula:
=$A$1*B3*INDIRECT("Sheet2!"&ADDRESS(ROW()-3,COLUMN(),4,1,))+$A$1*B4*INDIRECT("Sheet2!"&ADDRE SS(ROW()-2,COLUMN(),4,1,))+$A$1*B5*INDIRECT("Sheet2!"&ADDRE SS(ROW()-1,COLUMN(),4,1,))
Regards,
Stefi
|