Excel Magic Trick #217: IF Function Text Logical Test

[MoniqueNJ]

@ExcelIsFun Hi, thx for ur videos. i am trying to add a text list, so that the value returns the number 1 in a cell regardless of what name is entered from the list i.e. =IF(B4="Steinberg""De Freitas",1,0)

De Freitas

DeGiglio

Kostulias

Mehta

Rubinstein

Steinberg

Wuestman

[ExcelIsFun]

@MoniqueNJ , try:

=ISTEXT(B4)+1

and copy formula down.

[jinn666]

Can you use multiple cell in this formula and instead of true or false make it add. example between cell b14 to ae14 it encounters the word "so" it adds 1, so if there are 16 so then the results will be 16. help?

[ExcelIsFun]

@jinn666 , maybe:

=COUNTIF(B14:AE14,"so")

[popcornfield1]

OH GODDDD you just saved my life! Thank you very much!

[ExcelIsFun]

@popcornfield1 , I am glad that this help!

[TheMasonah]

eth the Well Done

ot to =IF(B5="to","Well Done", "Whoops")

dna and =IF(B6="and","Well Done", "Whoops")

I am trying to create a Dolch word exercise for low ability young adults. I am putting a mixed up word in A column and If formula giving Well done if correct answer is put in B column. First row worked fine - (the) spelt correctly. Subsequent rows do not. All cells are formatted as text. Any ideas why.

[ExcelIsFun]

@TheMasonah , I am not sure. But THE best Excel question site is:

mrexcel [dot] com/forum

[nctennis2008]

I am looking to use an IF function that tests for the presence of text in a certain cell. Is this possible to be done?

[nah2323]

Wow, had i looked at your videos, I would have saved about 2 hours messing with logical functions on my last book.

Thank You!!

[ExcelIsFun]

You are welcome!

[JDeptuch1]

I'm trying to set up a questionnaire that will expand depending on how the user answers the questions. For example, if someone answers "yes," I'd like a checkbox series to appear so the user can further clarify the answer to the question. How would one do this in Excel?

[ExcelIsFun]

Try this video:

Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Drop

If that does not work, you may need VBA code. If this is the case post your question to THE best Excel site:

Mrexceldotcom/forum

[ExcelIsFun]

see e-mail.