[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

If Statement not returning correct  results

Posted on 2013-06-09
4
Medium Priority
?
400 Views
Last Modified: 2013-06-09
Hi Experts,

I have a workbook that contains a sheet populated from a SharePoint site.

Within this sheet I am attempting to add calculated columns for a pivot table.

This is a simple test formula I have inserted in cells W:
=IF((Y2 > X2), "Inflow","Continued")

The results are in the attached file (with the 3 columns and a few rows copied to a new book).

This formula is returning "Continued" whether the date in column Y is greater than the date in column X.

I am looking for it to return "Inflow" if the date in Y is older than the date in X, and "Continued" if the date in Y is more recent than the date in X.

What am I doing wrong?

Thanks
Book5.xls
0
Comment
Question by:SASnewbie
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Martin Liss earned 2000 total points
ID: 39233035
The columns in your posted sheet don't match your description of the problem and do you realize that the years in column B are 2103 rather than 2013?
0
 

Author Comment

by:SASnewbie
ID: 39233044
Wow.....

Looking at it so long, I didn't even see that!

Corrected the year, and it works just fine.

Thank you!
0
 
LVL 50

Expert Comment

by:Martin Liss
ID: 39233048
You're welcome and I didn't see it at first either:)

Marty - MVP 2009 to 2013
0
 

Author Comment

by:SASnewbie
ID: 39233050
:)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question