Excel Magic Trick #217: IF Function Text Logical Test
Loading...
Loading...
16,670
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (15)
-
@TheMasonah , I am not sure. But THE best Excel question site is:
mrexcel [dot] com/forum
-
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.
-
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?
-
You are welcome!
Loading...
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun1,211 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,344 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 9:59Excel Logic Functions - IF, AND, and ORby rrphillips9,050 views
- 7:11Excel 2007 Course: IF Function (Expert Lesson 3...by TheSmartMethod8,791 views
- 5:00Excel Tutorial - IF functionby supernicko7915,172 views
- 3:41Excel 2010: Conditional Formattingby gcflearnfree19,172 views
- 6:09When to use Excel's =IF() Functionby DannyRocksExcels6,996 views
- 6:45Excel Tutorial Using the IF AND and OR Function...by teachucompinc34,898 views
- 4:06Understanding the IF Function in Microsoft Excelby ontrackTV9,731 views
- 9:04IF Statement and Nested IF Statement in Excelby ExcelisHell25,443 views
- 5:04Excel Magic Trick #394: IF Function and Conditi...by ExcelIsFun12,133 views
- 6:08MS Excel, the "IF" Function, & Letter Gradesby kentuckyclassroom8,531 views
- 4:59Nested If( ) Functions in Excelby eLearningCentralia6,101 views
- 10:07Excel Magic Trick 369: Compare 2 Lists, Extract...by ExcelIsFun16,637 views
- 4:51Microsoft Excel #06: Using "IF" in Formulasby freetutorials238,773 views
- 10:22Excel Magic Trick #113: Nested IF & Short Term ...by ExcelIsFun6,372 views
- 3:54Excel Magic Trick #120: ISNUMBER & SEARCH funct...by ExcelIsFun7,644 views
- 10:50Excel Magic Trick #203: SUMIF function formula ...by ExcelIsFun43,565 views
@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
MoniqueNJ 1 month ago
@MoniqueNJ , try:
=ISTEXT(B4)+1
and copy formula down.
ExcelIsFun 1 month ago
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?
jinn666 1 month ago
@jinn666 , maybe:
=COUNTIF(B14:AE14,"so")
ExcelIsFun 1 month ago
OH GODDDD you just saved my life! Thank you very much!
popcornfield1 2 months ago
@popcornfield1 , I am glad that this help!
ExcelIsFun 2 months ago