ISTEXT formula not working

sachavez

Active Member
Joined
May 22, 2009
Messages
446
Excel 2007

It's early for a Sunday morning and my brain is not fully awake.

I'm having trouble with the following formula:

=IF(D6(T),IF(E6=D6,1,O),"")

Basically, I'd like Excel to determine if there's text in cell D6:

If true, then compare CELL C6 with D6, if they match, the cell with the formula will display a 1. If they don't match, the cell will display 0 (zero).

If false, display nothing.

Thanks in advance.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
Your title says ISTEXT formula not working, but your formula does not use ISTEXT. :confused:

Try using ISTEXT() in your formula.
 

sachavez

Active Member
Joined
May 22, 2009
Messages
446
Re: ISTEXT & T formulas not working

Sorry, confusing, I know.

I tried using both formulas, but no success with either.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
Re: ISTEXT & T formulas not working

Sorry, confusing, I know.

I tried using both formulas, but no success with either.
Show us the formula with ISTEXT that you tried.
 

sachavez

Active Member
Joined
May 22, 2009
Messages
446

ADVERTISEMENT

I was able to get the following formula TO WORK:

=IF(ISTEXT(D6),IF(E6=D6,1,0),"")

Here's a more detailed look:

Excel Workbook
DEFGH
5Fight WinnerPlayer 1WinsPlayer 2Wins
6Frankie EdgarBJ Penn0Frankie Edgar1
7James ToneyRandy Couture0Randy Couture0
Card
 
Last edited:

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
I was able to get the following formula TO WORK:

=IF(ISTEXT(D6),IF(E6=D6,1,0),"")
That looks fine. Why are you testing column D with ISTEXT? Doesn't it always contain text (or blank)? If it is always text or blank then it may be a bit simpler to use:

=IF(D6="","",IF(E6=D6,1,0))
or even
=IF(D6="","",--(E6=D6))
 

sachavez

Active Member
Joined
May 22, 2009
Messages
446
Peter,

You pose a good question. Either of the formulas will work. I guess I like doing things the hard way!

You are up late: it's almost midnight where you are (you probably know that too!).

Take care, and thanks for the help.

Steve
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,501
Messages
5,511,691
Members
408,859
Latest member
willm57

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top