ISTEXT formula not working

[sachavez]

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.

 

[Peter_SSs]

Your title says ISTEXT formula not working, but your formula does not use ISTEXT.

Try using ISTEXT() in your formula.

 

[sachavez]

Re: ISTEXT & T formulas not working

Sorry, confusing, I know.

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

 

[Peter_SSs]

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]

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
	D	E	F	G	H
5	Fight Winner	Player 1	Wins	Player 2	Wins
6	Frankie Edgar	BJ Penn	0	Frankie Edgar	1
7	James Toney	Randy Couture	0	Randy Couture	0
Card

 

[Peter_SSs]

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]

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