Calculate a Percentage

[Joe C]

I know this is probably a silly ? but I'm a newbe. I have 3 fields
#1 Total Costs
#2 Total Sales
#3 Profit

I would like to show what percentage the Total Costs are of the Total
Sales as well as the percentage of profit is of the Total Sales

Thanks to all

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
if these values are in cell A1:A3 use
=A1/A2

and
A3/A2

both cells formated as percentage

 

[Joe C]

Thanks

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **