Results 1 to 6 of 6

IF function displays wrong information after using MID function

Threaded View

  1. #1
    Registered User
    Join Date
    04-12-2010
    Location
    *
    MS-Off Ver
    Excel 2007
    Posts
    25

    IF function displays wrong information after using MID function

    Hi,

    Okay, so:
    A1 displays "127:15" (no quotes, text cell).
    A2 has the function MID(A1,1,3), to retrieve the number "127".
    A3 has the function IF(A2>186,"yes","no").
    A3 says: yes.
    Why?

    Thank you all!
    Last edited by blackmilk; 04-12-2010 at 11:09 AM.

Thread Information

Users Browsing this Thread

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

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