View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Douglas Douglas is offline
external usenet poster
 
Posts: 35
Default Can I total only a % of a number (cell) base on total of all cel

I have a set of number and only want to total a part of each cell. Similar
to your taxes when the amount you can count is based on the grand total.

I have 17 different categories (cells) and only want to count 5.8% of each
catergory as a maxium amount base on the grand total.

Ex: It the grand total is 100 and one cell equals 30 then it would only
count as 5.8 points. if another cell equaled 3 then it would only equal 3
when added with the 5.8

I hope I have explained this in a way that someone can please help. I am
working on a project for a school contest scoring and need some help.

Thanks,
Douglas