Results 1 to 7 of 7

Classifying Data by use of an IF AND Statement

Threaded View

  1. #1
    Registered User
    Join Date
    08-09-2010
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2003
    Posts
    9

    Classifying Data by use of an IF AND Statement

    Hi, sorry for incorrectly titling my last post. I have attached a sample.
    Here is what I am trying to do:
    I have to classify data into 3 "buckets" based on criteria.


    To be a Good: Column B has to be a negative (<0) AND Column C has to be less than 200%
    To be Fair: Column B has to be between -4% and +4% AND Column C has to be between 200% and 300%.
    To be classified as Poor - all else.

    Attached Files Attached Files
    Last edited by analyst1; 09-15-2010 at 03:38 PM. Reason: Improper title

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