Results 1 to 10 of 10

Logical , functions , on ( IF , AND , OR)

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    Johannesburg
    MS-Off Ver
    Excel 2007
    Posts
    10

    Logical , functions , on ( IF , AND , OR)

    Good Day, Hope somebody can assist me with this logical and mindboggling functions.
    I am trying to group a rating on point system say for instance between 55 - 65 ( 5 points ) , 66 - 76 ( 10 points ) 77 -87 ( 15 points ) 88 - 98 ( 20 points ) ansd so forth.

    the Formula that i tried to use is in D1 whiich is =IF(AND(B2>113,B2>103),"25",IF(AND(B2>102,B2>92),"20",IF(AND(B2>91,B2>81),"15",IF(AND(B2>80,B2>70),"10",IF(AND(B2>69,B2>59),"5",IF(AND(B2>55,B2>65),"5"))))))

    In (B2: B6) is the ratings , 100, 95, 75, 69, 65, 88.

    The issue is the points returned in D1: D6 looks incorreect as 15 , 5 , 5 , False , 10 , False .

    From my understading it should have returned 20 , 20 , 10 , 5 , 5 , 10 if i correct.
    Attached Files Attached Files

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