Greater than or less than

For the following examples, assume that you want to compare income against expenses on a weekly basis. We'll run a few different calculations to see how to compare these two numbers. 

Greater than

First, check if income is greater than expenses. If income is greater than expenses, the result of the formula will be a 1 (meaning true), and if not, a 0 (meaning false).

{Income} > {Expenses}

Less than

Now, check if income is less than expenses. If income is less than expenses, the result of the formula will be a 1, and if not, a 0.

{Income} < {Expenses}

Greater/less than or equal to

Greater than or equal to

Similar to the formulas above, we can compare if income is greater than or equal to expenses (still returning a 1 or 0). The difference is most obvious in the below table when the Income and Expenses are equal—the formula returns 1.