Can I total only a % of a number (cell) base on total of all cel

[Guest]

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

 

[jIM]

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

not clear to me what you are asking

is a grand total the sum of the 17 cells?
is 5.8 the max number of points allowed per category

if (cell>5.8) add 5.8
if (cell<5.8) add cell

is this what you mean?

 

[Guest]

YES the grand total is the sum of the 17 different cells and I need a grand
total while I can do, BUT I also need to re-add the 17 cells and not let any
cell count more the 5.8% toward a NEW total. What I am need is two totals
one based on ALL the points and one based on ALL the cells but not greater
then 5.8% of the total. What I am trying to do is find the best overall
student and not have them run away with a contest in ONE area and not do well
in another area. There are 17 area they are judge and recieve points, but
the best student will be based on the final sum.
I am fairly new to excel so I will need a little help with where to place
these tip you share.

Thanks for your help.