Question about Microsoft Excel for PC
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
Correction to your code
version of formula that will work
Posted on Jan 08, 2009
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jan 06, 2011 | Computers & Internet
Oct 31, 2007 | Microsoft Excel for PC
Sep 23, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
268 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: