Results 1 to 6 of 6

Need help with IF function in a formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-15-2014
    Posts
    3

    Need help with IF function in a formula

    I’m hoping someone can help with a formula.
    If the data looks like this:
    10
    7
    6
    10
    9
    9
    3

    What would the formula be to calculate that array of values = 57% because 4 of them are equal to or greater than 9, and there are 7 of them in total? The formula should accommodate however many numbers are listed and calculate what percentage of them are 9 or 10.

    Thank you.
    Last edited by RonAR; 06-15-2014 at 12:50 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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