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%.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |