Something like

=MIN(10%*SUM($A$1:$A$100),IF(B1="",0,A1/B1))

copied down

Regards,

Peo Sjoblom

"needhelp" wrote:

In column "A" I have a value of 100. In column "B" I will have a number
ranging from 1 to 100. I want column "C" to divide column "A" by the number
in column "B", the number in column "C" cannot exceed 10% of the total in
column "A".

What would the formula be?