ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Percentages (https://www.excelbanter.com/excel-worksheet-functions/158341-percentages.html)

Steve

Percentages
 
I have a group of building that equal 911,815 Gross Square footage
Each building has a set gross square footage, one is 115,325 GSF
How do I figure what percentage of the total gsf each of the building
come out to be.

--
Thank You
Steve

Mike H

Percentages
 
divide the footage of each building by the total and multiply by 100. For the
building mentioned:-

=115325/911815*100 = 12.65%

Just one point, 911815/115325=~7.9 so all the building aren't the same size
as you seem to indicate.

Mike

"steve" wrote:

I have a group of building that equal 911,815 Gross Square footage
Each building has a set gross square footage, one is 115,325 GSF
How do I figure what percentage of the total gsf each of the building
come out to be.

--
Thank You
Steve


Steve

Percentages
 
Thank you I'll try it Now

--
Thank You
Steve


"Mike H" wrote:

divide the footage of each building by the total and multiply by 100. For the
building mentioned:-

=115325/911815*100 = 12.65%

Just one point, 911815/115325=~7.9 so all the building aren't the same size
as you seem to indicate.

Mike

"steve" wrote:

I have a group of building that equal 911,815 Gross Square footage
Each building has a set gross square footage, one is 115,325 GSF
How do I figure what percentage of the total gsf each of the building
come out to be.

--
Thank You
Steve



All times are GMT +1. The time now is 04:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com