Printable View
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.
Thanks
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.
thanksQuote:
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.