Hi, I am trying to apply multiple % calculations, one as a premium % and one as a discount % and I am unable to get the formula to take into account the multiple sums. The only way I am currently able to make the calculation work is by having a separate table working out the percentages first - can anyone help please.

Many thanks

The table would look something like :


A.................D1
...................B1
E1.....C1.......F1
E2.....C2.......F2

These represent the following:

A = Cost per Unit
B = No. of Units
C = No. of Weeks
D = Units % +Premium or -Discount
E = Weeks % +Premium or -Discount
F = Total Value Payable

The formula needs to match the following values:

Example 1 -

A = £100
B1 = 2
C1 = 4 Weeks
D1 = 10% Premium
E1 = 10% Premium
F1 = £960


Example 2 -

A = £100
B1 = 2
C2 = 13 Weeks
D1 = 10% Premium
E2 = 5% Discount
F2 = £2,730