A missing value can lead to confusion by returning error values. But a properly used Nz() function can turn an error message into an understandable and expected value ...

Don't let Null values derail your formulas. See how to use the NZ function to convert the values to zeroes.