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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brad Gover

    inbedded functions in functions

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

    if function and ifblank() function

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

    formula/functions for average and if functions

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

    Help IfBlank use data from next cell

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

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

Share This Page