Working out Average Profit from Total Sales and Average Profit Margin

[scotty298]

Hello,

I need to work out the total value from 2 fields

Q4 = Total Sales = £25,137.90
R4 = Average Product Profit Margin % = 25%

Basically 28% of £25,137.90.

I have currently got the sum - =Q4*R4

However, this gives me £15,911.76. This is incorrect as 28% is £15,807.34.

Please note that;
Q4 is the fields Jan - Dec added together to get total - =SUM(B13:M13)
R4 is from a different excel sheet but is just - ='
[Listing Audit.xlsx]Report Data'!$B$4
The formula in listing audit is =AVERAGE(B2:B3)

Thanks
Paul

<tbody>
</tbody>

​