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.
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,064
Office Version
  1. 365
Platform
  1. 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
49,064
Office Version
  1. 365
Platform
  1. 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
49,064
Office Version
  1. 365
Platform
  1. 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
 

Watch MrExcel Video

Forum statistics

Threads
1,132,679
Messages
5,654,712
Members
418,149
Latest member
tjanok

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top