Results 1 to 18 of 18

Fail to compare text in two cells with IF

Threaded View

  1. #1
    Registered User
    Join Date
    04-07-2019
    Location
    Hanoi, Vietnam
    MS-Off Ver
    16001.11425.20056.0
    Posts
    13

    Fail to compare text in two cells with IF

    Hello.
    I'm trying to do a little work on excel but it has the problem. I have a table like this:

    excel last season.png

    I want to check the season number in column E with the season number in column F so I write a formula like this:

    =IF(F2=("Season "&E2);"yes";"no")

    and put it into column G said cell G2. But it says "no" for every pair even if the number is the same. I think it was because the format of the two things weren't the same so I changed to another formula which I know a little information from Google. It was:

    =IF(TEXT(F2;"0")=TEXT("Season "&E2;"0");"yes";"no")

    But this time it said "no" for everything also even the number was the same.
    Any one tell me know what's wrong with my formulas please. I think I didn't know something that I should have known.
    Thanks.
    Last edited by AliGW; 08-13-2019 at 05:16 AM. Reason: Irrelevant section of title removed.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make a cell display "FAIL" when range of cells is FAIL
    By crazychile in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2017, 04:13 PM
  2. Help with Pass/Fail Problem
    By clooysen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2016, 09:39 PM
  3. [SOLVED] Need a formula for pass/fail based on no. of Y answers but automatically fail if 3a is N
    By Researcher1111 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-15-2013, 10:20 PM
  4. Replies: 2
    Last Post: 01-30-2013, 12:59 PM
  5. Compare two text cells and extract common text words
    By ghost_chip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2012, 06:07 AM
  6. [SOLVED] Problem with code. (Compare all cells)
    By Metrazal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-10-2006, 03:34 PM

Tags for this Thread

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