+ Reply to Thread
Results 1 to 10 of 10

Calcualte Percent when cell equals N/A

  1. 06-26-2013, 10:15 PM #1
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Calcualte Percent when cell equals N/A

    Hello Excel Guru's

    I am sure this is an easy fix for all you Pro's - Thanks in advance.

    Excel 2003

    In this workbook you will see to charts B7:G20 and B28:G41

    The cells C8:G20 and G29/G41 will equal Yes, No or N/A

    There could be a whole column that equals N/A and this is where I need the help.

    After the selections are made in the above charts the info is carried over to J8:J12

    2 asks

    • What I need is if any one of the cells in J8:J12 do not calculate because of an N/A entry from the charts I want that cell to also so N/A
    • I then need to take an average of the cells J8:J12 for an overall average (Cell L8) of the 5 elements but I need the result even if there is an N/A in J8:J12

    If my current set up does not work feel free to make another suggestion.
    Attached Files Attached Files
    Last edited by SVTF; 06-26-2013 at 11:01 PM.
    Reply With QuoteRegister To Reply
  2. 06-26-2013, 10:32 PM #2
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Calcualte Percent when cell equals N/A

    J8=IF(ISERROR(formula),"NA",formula)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  3. 06-26-2013, 10:35 PM #3
    wenqq3
    wenqq3 is offline
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Calcualte Percent when cell equals N/A

    CEI Tactic Calculator(EDIT).xls

    Is this OKIE?
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++
    Reply With QuoteRegister To Reply
  4. 06-26-2013, 10:42 PM #4
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Calcualte Percent when cell equals N/A

    Quote Originally Posted by vlady View Post
    J8=IF(ISERROR(formula),"NA",formula)
    Quote Originally Posted by wenqq3 View Post
    Attachment 246065

    Is this OKIE?
    Thanks to both of you ... Works as I need it to.
    Reply With QuoteRegister To Reply
  5. 06-26-2013, 10:46 PM #5
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Calcualte Percent when cell equals N/A

    You're welcome from both of us.

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  6. 06-26-2013, 10:48 PM #6
    wenqq3
    wenqq3 is offline
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Calcualte Percent when cell equals N/A

    Welcome, thanks for feedback :D
    Reply With QuoteRegister To Reply
  7. 06-26-2013, 10:56 PM #7
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Calcualte Percent when cell equals N/A

    Small Tweak ...

    If there is a cell that equals N/A in J8:J18 ... I don't want the average in L8 to drop it because of the N/A
    • Example if 4 of the 5 cells equals 100% and the 5th Cell is N/A .. result should still be 100%
    Last edited by SVTF; 06-26-2013 at 10:58 PM.
    Reply With QuoteRegister To Reply
  8. 06-26-2013, 10:59 PM #8
    wenqq3
    wenqq3 is offline
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Calcualte Percent when cell equals N/A

    Okie, then you can just ignore the red cell that i highlighted. Your formula is working well.
    Reply With QuoteRegister To Reply
  9. 06-26-2013, 11:00 PM #9
    SVTF
    SVTF is offline
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: Calcualte Percent when cell equals N/A

    Quote Originally Posted by wenqq3 View Post
    Okie, then you can just ignore the red cell that i highlighted. Your formula is working well.
    Of course it is .. LOL .. Silly Me.

    Thank You so much.
    Reply With QuoteRegister To Reply
  10. 06-26-2013, 11:00 PM #10
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: Calcualte Percent when cell equals N/A

    your formula =AVERAGE(J8:J12) will work
    if you dont want to include NA follow wenqq3 =sum/5
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1