# ISTEXT formula not working

#### sachavez

##### Active Member
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.

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

#### Peter_SSs

##### MrExcel MVP, Moderator
Your title says ISTEXT formula not working, but your formula does not use ISTEXT.

Try using ISTEXT() in your formula.

#### sachavez

##### Active Member
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
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
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
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
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

Replies
2
Views
316
Replies
1
Views
686
Replies
28
Views
378
Replies
0
Views
383
Replies
1
Views
246

1,171,186
Messages
5,874,241
Members
433,041
Latest member
spongeavenger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back