ExcelBanter - How do if create IF functions using text as the logical test?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do if create IF functions using text as the logical test? (https://www.excelbanter.com/excel-discussion-misc-queries/121829-how-do-if-create-if-functions-using-text-logical-test.html)

nellybean

How do if create IF functions using text as the logical test?

T. Valko

How do if create IF functions using text as the logical test?

A1 = Joe
B1 = 10

=IF(A1="Joe","Yes, A1 equals Joe","No, A1 does not equal Joe")

=IF(A1="Joe",B1*10,0)

=IF(AND(A1="Joe",B1=10),"Winner","Try again")

Biff

"nellybean" wrote in message
...

Gord Dibben

How do if create IF functions using text as the logical test?

=IF(A1="string","text in A1","no text")

=IF(ISTEXT(A1),"text","no text")

Either one will do.

Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 10:27:02 -0800, nellybean
wrote:

All times are GMT +1. The time now is 12:33 AM.