View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pasko1
 
Posts: n/a
Default Calculate gross profit based on varying percentages

I am trying to calculate, based on a known product cost, what the gross sales
and gross profit dollars would be as a result of different GP percentages.

I.E. Here is some data for my company's products:

Sales Cost GP $ GP %
$208,400 $197,354 $11,046 5.3%
$201,786 $191,066 $10,720 5.3%
$89,421 $82,452 $6,969 7.8%
$78,808 $71,891 $6,917 8.8%
$63,114 $58,706 $4,407 7.0%

If I wanted to figure out how much the GP $ and Sales were for the first row
using a GP % of 22%, for example, how could I calculate them? Thank you.