Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an action based on the result.

How to use a formula to suppress 0 in a cell in Excel When using an expression that might return a zero, you can wrap that expression in an IF () function to suppress a zero result.