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?

One way:

=MIN(A1/B1,10%)

Or, if B1 may be empty:

=IF(B1<0,MIN(A1/B1,10%),"")

In article ,
"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".

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?