I have defect percentage in column F and I want to calculate Six Sigma Level corresponding to defect value
I am using below formula in excel and that giving me correct sigma level
=IFERROR(NORMSINV(1-F5)+1.5,"0")
F5 has defect percentage in excel sheet
Example;
Defect % Sigma Level
0.0230% 5.00
0.0210% 5.03
0.0180% 5.07
0.0160% 5.10
0.0140% 5.13
0.0120% 5.17
0.0090% 5.25
0.0070% 5.31
0.0050% 5.39
0.0030% 5.51
I have been trying to create VBA code but not able find correct sigma level, may be because of NORMSINV function not available.
Please help me to resolve. I need VBA code so that sigma level is calculated for each row having defect percentage only.
Bookmarks