Can you take a look at the attached form? I am having to do some data manipulation at my new job. This is the first time I have had to calculate these areas. Can you tell me if the formulas are correct so when I place the "real" data it comes out correct?
To see it on Excel just change the file extension back to .xls.
Since this is a VBA Forum, I was expecting a question on Visual Basic for Applications (VBA) problems.
The question you have is more like Math question (there is a special Forum on this)
On your question, from my point of view you formulas used seem to be correct (if the definition of profit profit is correct in the view of your company).
The only mistake is in the line profit margin, in order to get the Total Product Margin, you can not just add the percentages, you have to calculate that out of the Totals of Sales Revenue and Product Profit.
You're welcome to rate this post!
If your problem is solved, please use the Mark thread as resolved button Wait, I'm too old to hurry!
Originally posted by opus Since this is a VBA Forum, I was expecting a question on Visual Basic for Applications (VBA) problems.
The question you have is more like Math question (there is a special Forum on this)
On your question, from my point of view you formulas used seem to be correct (if the definition of profit profit is correct in the view of your company).
The only mistake is in the line profit margin, in order to get the Total Product Margin, you can not just add the percentages, you have to calculate that out of the Totals of Sales Revenue and Product Profit.
Profit Margins in Excel
Reply With Quote
