Step 2: Select the date column (column A) as the range (A2:A13). The COUNTIF function helps count the cells within a particular range based on a criterion. We want to count the number of invoices that are sent on or after 14 th March 2019. The following table shows the date and amount of the invoices sent to the buyer. For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” It is used to count cells that include dates, numbers, or text. Let us use the comparison operator “greater than or equal to” with the COUNTIF COUNTIF The COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. Example #3–“Greater Than or Equal to” With the COUNTIF Function Since the values in the cells B5, B11, B12, and B13 are greater than $6500, we get the respective incentive amounts in column C. Step 5: Drag the formula to the remaining cells, as shown in the following image. This implies that the value in cell B2 is less than $6500.
In cell C2, the formula returns the output 0. So, we type zero at the end of the formula. Step 4: If the logical test is “false,” the incentives are 0. Step 3: The condition is that if the logical test is “true,” we calculate the incentives as B2*10%. If the total sales>$6500, incentives are calculated at 10%.The monthly incentives are calculated by comparing the sales against the benchmark of $6500. The following table shows the total sales (in dollars) of various months. It is a conditional function of Excel, which returns the result based on the fulfillment or non-fulfillment of the given criteria. Let us use the comparison operator “greater than or equal to” with the IF condition IF Condition IF function in Excel evaluates whether a given condition is met and returns a value depending on whether the result is “true” or “false”. This implies that the value of cell A4 is either greater than or equal to 50.Įxample #2–“Greater Than or Equal to” With the IF Function The “greater than or equal to” operator returns the value “true” in cell B4. To include 50 in the test, we need to change the comparison operator to “greater than or equal to” (>=). The value of cell A4 (50) is not greater than the number 50. The cells in yellow contain a number greater than 50. Copy and paste or drag the formula to the remaining cells. Press the “Enter” key to obtain the result.Since we want to test whether the value in cell A2 is greater than 50 or not, type the comparison operator (>) followed by the number 50.Select the cell A2 that is to be tested.Type the “equal to” (=) sign in cell B2.The steps to test the greater number are listed as follows: The “asterisk,” “forward slash,” and “caret” are used for multiplication, division, and exponentiation respectively. These operators are used in calculations to generate numeric output. The arithmetic operators like “plus” (+), “minus” (-), “asterisk” (*), “forward slash” (/), “percent” (%), and “caret” (^) symbols are used in formulas. The logical operators help draw relevant conclusions which are used in the decision-making process. Since logical operators return only the Boolean values “true” or “false,” they are also called Boolean operators. Likewise, every logical operator Logical Operator Logical operators in excel are also known as the comparison operators and they are used to compare two or more values, the return output given by these operators are either true or false, we get true value when the conditions match the criteria and false as a result when the conditions do not match the criteria. The “equal to” (=) symbol, used in mathematical operations, helps find whether two values are equal or not. Example #4–“Greater Than or Equal to” With the SUMIF Function.
Example #3–“Greater Than or Equal to” With the COUNTIF Function.Example #2–“Greater Than or Equal to” With the IF Function.Example #1–“Greater Than” and “Greater Than or Equal to”.