Excel IF Function If Cell Contains Specific Text - Partial Match IF Formula

In this video, I'll show you how to use the Excel IF function to test IF a cell contains specific text. The video contains 2 examples of using the CONTAINS function to check that the cell contains a partial or exact match. You can combine the CONTAINS function with the IF function to perform various tests.

Download DataFX free function library:

Chapters:

00:00 Intro
00:08 IF Cell Contains Specific Text - Partial Match
01:05 IF Cell Contains Specific Text - Exact Match

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

🎁 SHARE this video and spread the Excel love.

Or if you are in a hurry, please click the 👍

#exceltips #exceltutorial #excel

[chrislovescoke]

What version of Excel is this? I'm on the latest version (Office 365) and there is no "Contains" function.

[sav]

Hi am trying to design a payroll in excel, so for example if i add a payroll number in any order on the column how can the payroll number identify a persons name. thank you

[gymweeb]

Thanks.
I am currently trying to make a formula that allows me to add up costs from another sheet if they are from a certain store.
So I would use the IF function to see if they are from ''insert store name'' in the list and locate the cell of that line that has the transaction cost, so it can be added up all in one cell in a table.
That is possible right?

[paigephilyaw]

I have downloaded all your add in's and the "contains" function still doesn't work.

[santoshkrishnan]

I am placing/writing a formula in cell C1

In A1 - Its EXPIRY DATE
In B1 - Its RENEWAL DATE
=IF(TODAY()>=B1, "SEND RENEW REMINDER", "WAIT")
The above formula is working.

Now, I want to apply one more condition in same cell C1 - That if A1 is less than TODAY's date, the result should be "PENDING" and if I write manually (CANCELLED) in A1, the result should be "CANCELLED". Something like =IF(TODAY()<A1, "PENDING") =IF(A1=CANCELLED, "CANCELLED")

I am finding difficulty to apply the second condition merging with first condition in the same cell.

Please help me out.

[TsuDenom]

Excel Bootcamp - this CONTAINS function - just like the COMPARE function does not work - please explain/guide or I trust that this is not a scam video that needs to be reported!!