Results 1 to 7 of 7

Nested IF statement Trouble

Threaded View

mzbhvin Nested IF statement Trouble 09-10-2009, 10:45 AM
Palmetto Re: Nested IF statement... 09-10-2009, 10:52 AM
mzbhvin Re: Nested IF statement... 09-10-2009, 11:46 AM
teylyn Re: Nested IF statement... 09-10-2009, 06:20 PM
daddylonglegs Re: Nested IF statement... 09-10-2009, 07:16 PM
teylyn Re: Nested IF statement... 09-10-2009, 08:36 PM
mzbhvin Re: Nested IF statement... 09-10-2009, 09:10 PM
  1. #1
    Registered User
    Join Date
    09-10-2009
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    3

    Nested IF statement Trouble

    I am getting very frustrated and I think I just need another set of eyes to see this.

    this is a little complicated, but here's what I'm trying to do...

    I'm creating a bowling spreadsheet that displays awards won depending on what the person bowled, their average, and scores.

    A bowler bowls 3 games. I need to know if any of those games deserve an award based on all of this criteria..

    If they have bowled 21 games, check to see if current average is 90 or below
    If they have not bowled 21 games, check to see if last years average is 90 or below. (if they bowled 21 games or more, do not check last years average)
    If the average is 90 or below, then check to see if any of the 3 games are between 125 and 149.

    If they're average is 90 or below and they bowled between 125 and 149, they receive an award.

    I know this sounds a little confusing, but I'm at a loss. I think I have so many IF, AND and OR statements that I got really confused myself.

    Thank you for any help you can give me.
    Last edited by mzbhvin; 09-10-2009 at 09:20 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