Results 1 to 4 of 4

IF function not performing as expected

Threaded 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
« 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