A Curse | search
Click here to view A Curse news from 60+ newspapers.
Bookmark or Share- Use AND and OR to test a combination of conditionsWhen you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's an example:
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- Combine text and numbers - Microsoft SupportLet's say you need to create a grammatically correct sentence from several columns of data to prepare a mass mailing. Or, maybe you need to format numbers with text without affecting formulas that use those numbers. In Excel, there are several ways to combine text and numbers.
- Create conditional formulas - Microsoft SupportTesting whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. Formula that uses the IF function. logical_test: The condition that you want to check.
- REGEXEXTRACT Function - Microsoft SupportYou can extract the first match, all matches or capturing groups from the first match. The REGEXEXTRACT function extracts strings within the provided text that matches the pattern. The syntax of the REGEXEXTRACT function is: REGEXEXTRACT (text, pattern, [return_mode], [case_sensitivity])
More
