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...categories.htm **

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

and
A3/A2

both cells formated as percentage

--
Regards
Frank Kabel
Frankfurt, Germany

"Joe C" <(E-Mail Removed)> schrieb im Newsbeitrag
news:4151e78d$0$26174$(E-Mail Removed)...
> 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...categories.htm **

Thanks

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