AllExperts > Excel 
Search      
Excel
Volunteer
Answers to thousands of questions
 Home · More Excel Questions · Answer Library  · Encyclopedia ·
More Excel Answers
Question Library

Ask a question about Excel
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jan Karel Pieterse
Expertise
Excel and Excel/VBA questions

Experience
Excel MVP

Organizations
Self employed Excel developer

Education/Credentials
Bachelor in Chemical Engineering

Awards and Honors
Microsoft MVP award since 2002

Past/Present Clients
Shell, Fortis bank, ABN-AMRO bank, Morgan Stanley, ...

 
   

You are here:  Experts > Computing/Technology > Microsoft Software > Excel > Excel Formula Dilemma

Excel - Excel Formula Dilemma


Expert: Jan Karel Pieterse - 10/22/2009

Question
I have a compliancy report that lists how many times YES (column A), how many times NO (column B) and one column (column C) NOT APPLICABLE. How do I write the formula in Column D for a PERCENTAGE OF COMPLIANCE if A and B don't make a true total given the N/A figures? thanks!

Answer
Hi Chris,

I'm sorry but I fail to understand your question precisely.

What do you mean by "a true total given the N/A figures"?
You need a formula that sums the no's and yes'es and N/A's and check whether this total equals the number of answers?

Add to this Answer   Ask a Question


 
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.