Excel Forum

Excel Magic Trick 459: Non-Zero numbers = TRUE IF Function logical_test Argument Tricks

Learn about how the IF Functions logical_test interprets any non-zero number as TRUE and 0 (zero) as FALSE. See a formula that will hide formulas when no data is entered (or all the cells are blank), and see a formula for Standard Deviation of the sample that avoids using 0 zeroes in calculation.

Got a Question? Ask it Here in the Forum.