View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Help with formulae

That's exactly what my suggested formula does - calculates the gross
profit "from each relative to the total" gross profit.

The sum of the three weighted gross margins is the total gross margin
(e.g., in this case 5.8%).

Not sure what you mean by "a more 'mathematic' approach". There's no
need to back into anything when you can calculate it straightforwardly.

In article ,
Pivot Man wrote:

I was looking for a more "mathematic" approach that would use either the
Gross Margin, or Profit dollars from each relative to the total...or
somehting like that...I do appreciate the response.

Mathematically, I just cant figure out why I can't back into the 5.8% from
the available information.