I
IvorFreyrsson
Hi everyone!
This is my first time posting here. I've gotten a lot of great answers from these forums for my job, and since I cannot find an answer after two hours of searching, I figured it was time to make a profile, and get to asking.
I work in Quality Control, specifically Incoming Inspections. I also handle the management of our calibration system.
With that bit of background (it may help) I am posing a question to the larger body of learned minds.
I'm trying to make a formula that will calculate my sample size based off of an AQL standards chart. Our acceptance # is zero, but that won't play a part in my question.
In Excel, let's say I have six cells - A1:A3 and B1:B3
A1:A3 are only text; "AQL Level" (A1), "# of Samples" (A2) and "# Inspected" (A3)
In the other three cells: I have a drop-down in B1, giving the AQL number.
In B2 would go my total number of parts, i.e 450.
In B3, I'd like to develop a formula that will give me the proper # of parts to inspect, based off cells A1 and A2. I am stumped, as I'm not that great with Excel.
I think I'm in the right forum. If not, would you kindly point my noob self in the right direction?
This is my first time posting here. I've gotten a lot of great answers from these forums for my job, and since I cannot find an answer after two hours of searching, I figured it was time to make a profile, and get to asking.
I work in Quality Control, specifically Incoming Inspections. I also handle the management of our calibration system.
With that bit of background (it may help) I am posing a question to the larger body of learned minds.
I'm trying to make a formula that will calculate my sample size based off of an AQL standards chart. Our acceptance # is zero, but that won't play a part in my question.
In Excel, let's say I have six cells - A1:A3 and B1:B3
A1:A3 are only text; "AQL Level" (A1), "# of Samples" (A2) and "# Inspected" (A3)
In the other three cells: I have a drop-down in B1, giving the AQL number.
In B2 would go my total number of parts, i.e 450.
In B3, I'd like to develop a formula that will give me the proper # of parts to inspect, based off cells A1 and A2. I am stumped, as I'm not that great with Excel.
I think I'm in the right forum. If not, would you kindly point my noob self in the right direction?