Excel Forum
Similar Content
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
How to Use the IF Function in Excel
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF functi...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...

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.