# Sigma Calculation in Excel

M

#### MartyCalavera

Hello all, great forum you have here. Very helpful.

I was wondering if any Excel boffins could lend me a hand please? I have an excel spreadsheet which collates data given from a CMM and works out its capability and gives a sigma score. However, in the cases where processes are returning 0ppm, the formula displays the Sigma score as #NUM!. Could anyone inform me how to get it to read '6+' if the PPM score is 0?

This is formula used: "=-(NORMINV((A1/1000000),0,1)-1.5)" where 'A1' is the PPM.

Thanks All,
Marty

#### pkost

Trusted Information Resource
if(a1=0,"6+",-(NORMINV((A1/1000000),0,1)-1.5))

#### Steve Prevette

##### Deming Disciple
Staff member
Super Moderator
Using "iserror" is also a method to avoid such issues.

Calculation of PPM & Sigma Level in an Excel Spreadsheet Statistical Analysis Tools, Techniques and SPC 3
T Calculation of Sigma Level of Defects for a Manufacturing Process Statistical Analysis Tools, Techniques and SPC 8
B Why 3 sigma in Cpk calculation? Six Sigma 8
D Ppk - Capability calculation using the estimated sigma calculated from the Rbar/d2 Capability, Accuracy and Stability - Processes, Machines, etc. 16
What is the Cost of six sigma certification? Six Sigma 10
K Looking for a good Six Sigma book Six Sigma 7
N Student trying to apply Lean Six Sigma on a Construction project in my thesis Lean in Manufacturing and Service Industries 3
Lean Six Sigma for Quality Management System Lean in Manufacturing and Service Industries 10
ASQ Lean Six Sigma Conference March 4-5, 2019 - Phoenix, AZ ASQ - American Society for Quality 0
ASQ Lean Six Sigma Conference March 4-5, 2019 Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
S Levels of Lean Six Sigma Certification Six Sigma 3
Excellent Resource on Statistics / Lean / Six Sigma Book, Video, Blog and Web Site Reviews and Recommendations 2
UCL/LCL calculations using Sbar and sigma Statistical Analysis Tools, Techniques and SPC 2
M How Organizations maintain Six Sigma and TQM in their Operations ISO 13485:2016 - Medical Device Quality Management Systems 6
M Can Six sigma support ISO9001? If yes, in what ways? Lean in Manufacturing and Service Industries 5
L Toyota doesn’t use Six Sigma Six Sigma 1
N Implementation of Six Sigma in Service industry Service Industry Specific Topics 17
J Six Sigma Green Belt (SSGB) from a college - Options? Professional Certifications and Degrees 4
ASQ 2015 Lean Six Sigma Conference: Bev D's Presentation Problem Solving, Root Cause Fault and Failure Analysis 9
K Looking for Six Sigma Black Belt projects in Customer Service Six Sigma 7
Estimation Sigma (Within) when subgroup n=1 (MiniTab) Capability, Accuracy and Stability - Processes, Machines, etc. 6
Using Minitab to do 6 Sigma Studies Six Sigma 4
Total Productive Maintenance vs. Lean, Six sigma, Business Process Reengineering, etc Quality Tools, Improvement and Analysis 9
S Quality / 9001/ Six Sigma Audio CD Recommendations? Training - Internal, External, Online and Distance Learning 1
Advice for the Implementation of a Lean/Six Sigma Program Six Sigma 9
Application / Use of Hypothesis Testing in any Six Sigma Black Belt Project Six Sigma 8
Tools Six Sigma for my Automated Machine Six Sigma 8
V Pareto Analysis - Six Sigma - 'Productivity Improvement' project Service Industry Specific Topics 1
N Lean Six Sigma Deployment Six Sigma 2
G How much to pay a Freelance Six Sigma Trainer in India Six Sigma 1
M Six Sigma in the Software Industry Six Sigma 6
B Relating DPM, Sigma Quality, and Centering Statistical Analysis Tools, Techniques and SPC 2
G Looking for live project in company for Six Sigma Black belt Project Training - Internal, External, Online and Distance Learning 3
B How to identify Six Sigma Yellow Belt Project Six Sigma 4
O Main difference between X-bar sigma chart / X-bar range chart Statistical Analysis Tools, Techniques and SPC 4
D Calculating Lower and Upper 3 Sigma Control Limits Statistical Analysis Tools, Techniques and SPC 2
ASQ Six Sigma Handbook - Should I purchase the Black Belt handbook now? Six Sigma 5
Six Sigma Green Belt Certification help Career and Occupation Discussions 5
H Chosing a Six Sigma Green Belt Project - Software Industry Six Sigma 9
S Suggestions for Six Sigma Online Training Training - Internal, External, Online and Distance Learning 6
S Example of a DFSS (Design for Six Sigma) Project or a Case Study Six Sigma 4
S Lean Hospital - Implementing a quality/lean/six sigma program Lean in Manufacturing and Service Industries 3
B Calculating Combined DPMO and Sigma Level for Two or More Different Work Areas Six Sigma 3
S 6 Sigma Performance Level Six Sigma 4
K Choosing a Six Sigma training organization Six Sigma 4
C DFSS (Design for Six Sigma) project or SSBB project? Six Sigma 8
H Case Studies of Six Sigma in Service Processes Six Sigma 1
Establishing Sigma or Capabilty Indices for Automotive Safety Quality Tools, Improvement and Analysis 1
S Need help with Project Charter for my Six Sigma Green Belt Project Six Sigma 1
G Six Sigma Case Studies - Does anyone have a good source for LSS case studies? Six Sigma 8