Thread: Percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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