Results 1 to 4 of 4

Help with Formula for % Compliance

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2012
    Location
    Santa Barbara, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Exclamation Help with Formula for % Compliance

    Thank you in advance for helping me with this formula. I have attached a jpg of the form.

    In columns: Day1, Day2, Day3, Day4, Day5, Day6 each will have either Y, N, or NA. The formula will need to be in % compliance column. If there is a value of either Y or N in a cell it will count toward the % compliant, an NA will not affect the average, the average will only be taken on Y and N cells. So,

    If:

    Day1 Day2 Day3 Day4 Day5 Day6 %Compliance
    Y N Y Y Y NA 80% (should be the answer, this is where I need the formula)

    Thank you,

    Nancy
    Attached Images Attached Images
    Last edited by Maeeday; 01-04-2013 at 08:05 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1