ExcelBanter - Function Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function Help (https://www.excelbanter.com/excel-worksheet-functions/29860-function-help.html)

needhelp

Function Help

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?

JE McGimpsey

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".

Peo Sjoblom

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?

All times are GMT +1. The time now is 05:13 AM.