The Greater-Equal formula in Excel apply
Applied is the Greater-Equal-condition in the rule with the If function of Excel.
- Usually the function of three areas: If a condition is met, proceed according to Plan A, otherwise, Plan B comes into force. The Syntax would then look like this: =If(condition; then;else). Of course, you can also use only the first part of the formula, or different nesting levels of make - your imagination there are no limits.
- To illustrate this a small example: If a customer buy from you Goods to the value of at least 500 euros, he receives a Bonus of 10 Euro for his next purchase. That is, if in cell [B7] is a value that is greater than or equal to 500 eurois now, popping up in the cell [C7], the value of 10, otherwise the value 0.
- The Excel formula for cell [C7], would be established in the case, so: =If(B7>=500;10;0) (see figure).
Greater than or Equal to formula in Excel
You want to in Excel multiple columns to compare, this is also easily doable.
