Function Help

N

needhelp

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?
 
J

JE McGimpsey

One way:

=MIN(A1/B1,10%)

Or, if B1 may be empty:

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

Peo Sjoblom

Something like

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

copied down

Regards,

Peo Sjoblom
 
Top