Re: Using the IF and IFBLANK functions

Discussion in 'Microsoft Excel Worksheet Functions' started by Claus Busch, May 1, 2012.

  1. Claus Busch

    Claus Busch Guest

    Hi Jason,

    Am Tue, 1 May 2012 06:25:53 +0000 schrieb Superjase14:

    > Site 1 52 89 84 89 Excellent
    > Site 2 52 52 Average
    > Site 3 18 58 52 Good


    your values begin in A2, then try:
    =CHOOSE(COUNT(B2:E2),"Poor","Average","Good","Excellent")


    Regards
    Claus Busch
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, May 1, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Brad Gover

    inbedded functions in functions

    Brad Gover, Jun 30, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    744
    Norman Harker
    Jun 30, 2003
  2. WorkerB5

    Conditional Functions - logical functions based on volatile variables

    WorkerB5, May 14, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    707
    WorkerB5
    May 14, 2004
  3. Guest

    Nesting functions in the functions dialog box

    Guest, Jun 10, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    375
    Guest
    Jun 10, 2005
  4. Franz Verga

    Looking for a site with functions that substitute the ATP functions

    Franz Verga, Jun 24, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    374
  5. Bob Phillips

    if function and ifblank() function

    Bob Phillips, Sep 25, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    1,365
    Guest
    Sep 25, 2006
  6. Guest

    formula/functions for average and if functions

    Guest, Aug 5, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    375
    Sandy Mann
    Aug 5, 2007
  7. quzie

    Help IfBlank use data from next cell

    quzie, May 2, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    331
    Teethless mama
    May 2, 2009
  8. ifblank function

    , May 4, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    386
    Glenn
    May 4, 2009
Loading...