Microsoft Excel for PC Logo
Posted on Jan 08, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Using * in a EXCEL functions

For example in cell M2 there is the wording Quick Brown Fox Jumps Over The Lazy Dogs

Using COUNTIF(M2,="*FOX*"") produces a count of 1

Using IF(M2="*FOX*","YES","NO") produces NO as the result - I would have expect YES.

I was under impression that using *either side* of characters would work for IF function.

Your comments would be appreciated - thank you

1 Answer

Cosma Papouis

Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Master:

An expert who has achieved Level 3.

  • Master 409 Answers
  • Posted on Jan 08, 2009
Cosma Papouis
Master
Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Master:

An expert who has achieved Level 3.

Joined: Oct 02, 2008
Answers
409
Questions
2
Helped
120438
Points
1164

Correction to your code
=COUNTIF(M2,"*Fox*")

version of formula that will work
=IF(COUNTIF(M2,"*FOX*"),"yes","no")

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

301 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3269 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3869 Answers

Brad Brown

Level 3 Expert

19190 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...