2 occasions of percent calculations

[excelnoonie]

New here and not good in English so I put example to show my problem.

Columns A1 A2 A3 A4 A5
Values 9 19 10 25% 5%

Steps:

A1 x A2 x A3 - A4 - A5 and put result in column A6.

I can only calculate until the percentage discount in A4, but can't calculate the 5% commission in A5. How to do computation?

[p24leclerc]

What are those numbers you multiply (9, 19 and 10)? Do you really want to multiply them and why?

If total price is to be calculated as the product of the first 3 values then:
Discount should be calculated as A4*A1*A2*A3
Commission should be calculated as A5*(A1*A2*A3-A4*A1*A2*A3) because you want to calculate it about the net value which is the total minus the discount.

Total value would then be A1*A2*A3*(1-A4)*(1+A5)