Results 1 to 4 of 4

IF Formula to show only last 6 results

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    04-26-2015
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    502

    IF Formula to show only last 6 results

    Morning guys,

    I am having a bit of brain cramp trying to set up part of a league spreadsheet that will just show the last 6 game week results.

    At 1st glance it may seem to be a simple IF formula, however, game weeks are not always 7 days apart, neither do they have exactly 42 days between the six relevant game week spreads so an IF statement IF(GW?>42," ",GW?,IF(GW?>35," ",GW? and so on doesn't cut it.
    The sample has been set up to show what and where the results should be, the formulas to return Win, Loss, & Draw results are already in place (in the actual workbook) but I have added a few formulas as reference points to show the number of days between three different variables.

    Bottom line for the requirements are, at season start show the 1st 6 weeks results, at GW 7 start clear GW 1 and show GW 2 thru 7, and so on until the last 6 weeks of the season where the results would be static.

    I am going round in circles, getting the formula to work, I can get it for a few weeks then the formula fails and I need to start all over again.

    Hopefully I can get some advice from you chaps because I may be over thinking this.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula results to show as 0 if <0 or >40,000
    By bec_microsoft in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-18-2016, 12:01 AM
  2. [SOLVED] Using VLookup but results show formula instead of results...
    By excel me in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 11-28-2013, 09:40 PM
  3. Show results in formula bar
    By desktop in forum Excel General
    Replies: 1
    Last Post: 10-04-2012, 02:04 AM
  4. Only show formula results if not 0 (zero)
    By randolphoralph in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2008, 12:42 PM
  5. Show Formula Results in Status Bar
    By NoiCe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2008, 01:47 AM
  6. Some formula results will not show up in the cell
    By Space Elf in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] Some formula results will not show up in the cell
    By Biff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 07:05 AM

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