Results 1 to 4 of 4

IF AND or IF OR formula??

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2010
    Location
    Houston, TX
    MS-Off Ver
    Excel 2007
    Posts
    47

    IF AND or IF OR formula??

    C5 is age D5 is points E5 is tees F5 is handicap

    in cell E5 there are 3 possible tee options, Green (G), White (W) and Blue (B)

    criteria for G tees as follows:
    age 70 or more
    and/or age plus handicap = 80 or more

    criteria for W tees as follows:
    age 65 or more
    and/or age plus handicap = 70 to 79

    criteria for B tees as follows:
    age plus handicap is less than 69

    What is the correct formula for E5? I think I need something like: (worksheet is attached)
    IF(C5>70,"G",IF(AND(C5+F5>=80,"G",IF(AND(C5>65,"W",IF(AND(C5+F5>69,>70,"W"IF(AND(C5+F5<69,"B"))))
    Attached Files Attached Files
    Last edited by rwhite713; 07-14-2010 at 04:26 PM.

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