Just like Excel will handle standard arithmetic, there is also a way to create formulas that return TRUE or FALSE. These can be used to then create calculations that depend on the boolean result — calculate one way if true, calculate a different way if false.