Douglas wrote:
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 (cell5.8) add 5.8
if (cell<5.8) add cell

is this what you mean?