+ Reply to Thread
Results 1 to 2 of 2

If statement to add 1 if false

  1. #1
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    If statement to add 1 if false

    Trying to build pivot table to give me true TY vs LY sales numbers. Today is Tuesday 6/9/2015, LY the same Tuesday was 6/10/2014. I have the date broke up in to individual columns...one for month, day, year. I'm trying to add a column that will return the current value in the @Day field if @Ship Date is this year, and return the (current value + 1) in the @Day field if @Ship Date is last year. Below is not working.

    =IF(YEAR([@[Ship Date]]="2015"),[@Day],([@Day]+1))

  2. #2
    Forum Contributor
    Join Date
    07-18-2014
    Location
    Missouri, USA
    MS-Off Ver
    2010
    Posts
    175

    Re: If statement to add 1 if false

    Just remembered this is going to be a problem with the last day of every month.

    Anyone have any suggestions how to get a pivot table to pull in the right sales figures vs LY for each day?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can IIF Statement bring false statement?
    By jgomez in forum Access Tables & Databases
    Replies: 5
    Last Post: 07-19-2013, 06:16 PM
  2. If statement, answer is false, hide false.
    By Mel B in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-07-2013, 06:36 PM
  3. If statement with a range and true/false statement
    By aarleblanc in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-20-2012, 06:34 PM
  4. If Statement - False
    By Foxcan in forum Excel General
    Replies: 1
    Last Post: 06-23-2009, 03:16 PM
  5. If False statement
    By iangreen in forum Excel General
    Replies: 9
    Last Post: 06-19-2007, 08:18 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