HomeCelebsHow To Use “If Cell Contains” Formulas in Excel

How To Use “If Cell Contains” Formulas in Excel

Published on

spot_img

Excel Formula: If mobileular consists of

Generic components

 

Summary

 

To check for cells that incorporate positive textual content, you may use a components that makes use of the IF feature collectively with the SEARCH and ISNUMBER functions.  In the instance shown, the components in C5 is:

 

=IF(ISNUMBER(SEARCH(“abc”,B5)),B5,””)

 

If you need to test whether or not or now no longer the A1 mobileular consists of the textual content “Example”, you may run a components with a purpose to output “Yes” or “No” withinside the B1 mobileular. There are some of distinct approaches you may positioned those formulation to apply. At the time of writing, Excel is capable of go back the subsequent variations:

If mobileular consists of any fee

If mobileular consists of textual content

If mobileular consists of variety

If mobileular consists of particular textual content

If mobileular consists of positive textual content string

If mobileular consists of certainly considered one among many textual content strings

 

If mobileular consists of numerous strings

 

Using those scenarios, you’re capin a position to test if a mobileular consists of textual content, fee, and more.

 

Explanation: If Cell Contains

 

One quandary of the IF feature is that it does now no longer aid Excel wildcards like “?” and “*”. This clearly manner you cannot use IF with the aid of using itself to check for textual content which can seem everywhere in a mobileular.

One answer is a components that makes use of the IF feature collectively with the SEARCH and ISNUMBER functions. For example, when you have a listing of e mail addresses, and need to extract people who incorporate “ABC”, the components to apply is that this:

 

=IF(ISNUMBER(SEARCH(“abc”,B5)),B5,””). Assuming cells run to B5

 

If “abc” is determined everywhere in a mobileular B5, IF will go back that fee. If now no longer, IF will go back an empty string (“”). This components’s logical check is that this bit:

 

ISNUMBER(SEARCH(“abc”,B5))

 

Using “if mobileular consists of” formulation in Excel

 

The publications beneath had been written the use of the brand new Microsoft Excel 2019 for Windows 10. If you’re the use of a distinct model or platform, a few steps can also additionally vary. Contact our professionals in case you want any similarly assistance.

 

  1. If mobileular consists of any fee, then go back a fee

 

This situation lets in you to go back values primarily based totally on whether or not or now no longer a mobileular consists of any fee at all. For example, we’ll be checking whether or not or now no longer the A1 mobileular is clean or now no longer, after which go back a fee relying at the result.

Select the output mobileular, and use the subsequent components: =IF(mobileular<>””, value_to_return, “”).

For our example, the mobileular we need to test is A2, and the go back fee may be No. In this situation, you’d extrade the components to =IF(A2<>””, “No”, “”).

Since the A2 mobileular isn’t clean, the components will go back “No” withinside the output mobileular. If the mobileular you’re checking is clean, the output mobileular may even continue to be clean.

 

  1. If mobileular consists of textual content/variety, then go back a fee

 

With the components beneath, you may go back a selected fee if the goal mobileular consists of any textual content or variety. The components will forget about the alternative facts types.

 

Check for textual content

 

To take a look at if a mobileular consists of textual content, pick out the output mobileular, and use the subsequent components: =IF(ISTEXT(mobileular), value_to_return, “”).

For our example, the mobileular we need to test is A2, and the go back fee may be Yes. In this situation, you’d extrade the components to =IF(ISTEXT(A2), “Yes”, “”).

 

take a look at for txt

 

Because the A2 mobileular does incorporate textual content and now no longer a number of or date, the components will go back “Yes” into the output mobileular.

 

Check for a number of or date

 

To take a look at if a mobileular consists of a number of or date, pick out the output mobileular, and use the subsequent components: =IF(ISNUMBER(mobileular), value_to_return, “”).

For our example, the mobileular we need to test is D2, and the go back fee may be Yes. In this situation, you’d extrade the components to =IF(ISNUMBER(D2), “Yes”, “”).

 

take a look at for variety or date

 

Because the D2 mobileular does incorporate a number of and now no longer textual content, the components will go back “Yes” into the output mobileular.

 

  1. If mobileular consists of particular textual content, then go back a fee

 

To discover a mobileular that consists of particular textual content, use the components beneath.

Select the output mobileular, and use the subsequent components: =IF(mobileular=”textual content”, value_to_return, “”).

For our example, the mobileular we need to test is A2, the textual content we’re seeking out is “example”, and the go back fee may be Yes. In this situation, you’d extrade the components to =IF(A2=”example”, “Yes”, “”).

 

If mobileular consists of particular textual content, then go back a fee

 

Because the A2 mobileular does include the textual content “example”, the components will go back “Yes” into the output mobileular.

 

  1. If mobileular consists of particular textual content, then go back a fee (case-sensitive)

 

To discover a mobileular that consists of particular textual content, use the components beneath. This model is case-sensitive, which means that handiest cells with an specific in shape will go back the desired fee.

Select the output mobileular, and use the subsequent components: =IF(EXACT(mobileular,”case_sensitive_text”), “value_to_return”, “”).

For our example, the mobileular we need to test is A2, the textual content we’re seeking out is “EXAMPLE”, and the go back fee may be Yes. In this situation, you’d extrade the components to =IF(EXACT(A2,”EXAMPLE”), “Yes”, “”).

Because the A2 mobileular does include the textual content “EXAMPLE” with the matching case, the components will go back “Yes” into the output mobileular.

 

  1. If mobileular does now no longer incorporate particular textual content, then go back a fee

 

The contrary model of the preceding section. If you need to locate cells that don’t incorporate a selected textual content, use this components.

Select the output mobileular, and use the subsequent components: =IF(mobileular=”textual content”, “”, “value_to_return”).

For our example, the mobileular we need to test is A2, the textual content we’re seeking out is “example”, and the go back fee may be No. In this situation, you’d extrade the components to =IF(A2=”example”, “”, “No”).

 

If mobileular consists of particular textual content, then go back a fee (case-sensitive)

 

Because the A2 mobileular does include the textual content “example”, the components will go back a clean mobileular. On the opposite hand, different cells go back “No” into the output mobileular.

 

  1. If mobileular consists of certainly considered one among many textual content strings, then go back a fee

 

This components ought to be used in case you’re seeking to discover cells that incorporate at the least certainly considered one among many phrases you’re looking for.

Latest articles

How To Win The Trade On The NFP Calendar?

Before you begin using the NFP calendar to trade, it is important to set...

Bass Pro Shops Return Policy

People go to a store to purchase things. Maybe they are buying them to...

The 2022 Best Project Management Software

Project management software allows you to easily plan, assign tasks, and organize teams so...

The Pros and Cons of Corporate Purchasing Cards

Introduction Corporate purchasing cards are a new way to purchase goods and services for businesses....

More like this

How To Win The Trade On The NFP Calendar?

Before you begin using the NFP calendar to trade, it is important to set...

Bass Pro Shops Return Policy

People go to a store to purchase things. Maybe they are buying them to...

The 2022 Best Project Management Software

Project management software allows you to easily plan, assign tasks, and organize teams so...