Excel Magic Trick 1162

Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick

DESCRIPTION

For a column with Dates or Empty Cells, see how to run an inventory balance formula when a date is entered, but not when the cell is empty. See how to use a single cell reference and no comparative operator for the logical test argument in the IF Function. Learn that the logical-test argument in the IF function interprets non-zero numbers as TRUE and zero as False.
Cell References in Formulas that Point To Empty Cells Evaluate to Zero.
IF Function & Empty Cells, For Logical Test just Use Cell Reference.




Be the first to comment

Leave a Reply