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