USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
arguments
|
|
|
criteria
|
|
|
range
|
|
|
dialog
|
Detailed explanation-1: -You can use the AND, OR, NOT, and IF functions to create conditional formulas. For example, the IF function uses the following arguments. logical test: The condition that you want to check. value if true: The value to return if the condition is True.
Detailed explanation-2: -criteria-defines the condition that tells the function which cells to count. It can be a number, text string, cell reference or expression. For instance, you can use the criteria like these: “10", A2, “>=10", “some text".
Detailed explanation-3: -The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. This video is part of a training course called Advanced IF functions.
Detailed explanation-4: -To count the cells which have text value in them, enter the formula =COUNTIF(range, criteria) in the destination cell. This is the same as the previous case, but adding wildcard “?” together with “*” only counts the cells which have text values.