+ Reply to Thread
Results 1 to 4 of 4

IF function not performing as expected

Hybrid View

  1. 06-30-2016, 11:33 PM #1
    L.LEE
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    238

    IF function not performing as expected

    Hi, I have an IF statement that does not return the expected value.

    I don't understand why a cell that contains the text "yes" would be seen by excel to be greater than a date.

    thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-01-2016, 12:43 AM #2
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: IF function not performing as expected

    because it orders by alphanumeric. ie numbers first then text. Dates are numbers.
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  3. 07-01-2016, 01:00 AM #3
    L.LEE
    L.LEE is offline
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    238

    Re: IF function not performing as expected

    Sorry I don't understand the reply. If it goes by numbers first, and "yes" is not a number, why does it return TRUE?
    How should I write the formula so that it will return FALSE?
    Reply With QuoteRegister To Reply
  4. 07-01-2016, 01:32 AM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: IF function not performing as expected

    try
    Formula: copy to clipboard 
    =IF(N(A2)>=A1,TRUE,FALSE)
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vbTextCompare not performing as expected in vba
    By johnmerlino in forum Excel General
    Replies: 4
    Last Post: 07-10-2011, 02:49 PM
  2. performing sum function using code
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2011, 03:37 PM
  3. Multiple function not performing
    By Emcadams7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2011, 07:48 PM
  4. Performing Countif function within VBA
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2011, 05:51 PM
  5. Sub for performing a function across multiple worksheets
    By hermithead in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2010, 02:14 AM
  6. If Then Else not performing as expected
    By Alexander40 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2009, 05:06 PM
  7. Trunc Function not performing
    By cstauber in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2008, 09:19 AM
  8. [SOLVED] auto_open macro not performing as expected
    By Eric Winegarner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2005, 06:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1