Forum Discussion
Excel Formula to make a payout table
I have to make a formula that takes the total number of entries in Column A, multiplies that by ten, and then divides the sum of it in half, then takes half of that sum and divides it again by a perc...
It's not A formula (single formula), but two, since there are two different kinds of calculations there. (And I corrected your set of percentages so they add up to 50% as well)
The attached spreadsheet does it. You can change the numbers in column A, or extend it that list, and the formulas will accommodate those changes.