Working out Average Profit from Total Sales and Average Profit Margin

scotty298

New Member
Joined
Aug 28, 2018
Messages
1
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>




 

Forum statistics

Threads
1,082,618
Messages
5,366,619
Members
400,906
Latest member
incanus

Some videos you may like

This Week's Hot Topics

Top