Dec 07 2021 02:44 PM
Hello,
I'm reaching out to see if this is a possibility within the Excel function limits.
I'm looking for a way to input a specific range of number (quantity of lot sizes) and have it autofill another cell with "1 In 13" etc.
So, the end result would look like this
(Range Input) "Qty: 2 to 8" would populate "100%"
(Range Input) "Qty: 9 to 150" would populate "1 in 13"
(Range Input) "Qty: 151 to 280" would populate "1 in 20"
(Range Input) "Qty: 281to 500" would populate "1 in 29"
(Range Input) "Qty: 501 to 1200" would populate "1 in 34"
(Range Input) "Qty: 1201 to 3200" would populate"1 in 42"
(Range Input) "Qty: 3201 to 10,000" would populate "1 in 50"
(Range Input) "Qty: 10,001 to 35,000" would populate "1 in 60"
(Range Input) "Qty: 35,001 to 150,000" would populate "1 in 74"
(Range Input) "Qty: 150,001 to 500,000" would populate"1 in 90"
(Range Input) "Qty: 500,001 and over" would populate "1 in 102"
Dec 08 2021 05:25 AM
@Juliano-Petrukio - So, the sample data comes from the c=0 sampling plan for lot inspection based on an AQL of 1.0. The populated "1 in 13, etc" data provided below would be auto-generated based on a lot size qty entered in by the user.
Dec 09 2021 06:28 AM
Dec 09 2021 07:06 AM
SolutionDec 09 2021 07:46 AM
Dec 09 2021 08:25 AM
Dec 09 2021 08:38 AM
Dec 09 2021 08:44 AM
Dec 09 2021 07:06 AM
Solution