Excel Magic Trick 1402

Formula to Put Check Mark In Cell If Number Greater Than Zero

DESCRIPTION

See how to put a check mark in a cell when a number is greater than zero using the IF Function and the CHAR function:
(00:11) Introduction
(00:41) Insert a Symbol
(01:28) Generate full list of all 255 ASCII Characters using two tricks: 1) Right-click Trick to fill column with Series of numbers 1 to 255. See the CHAR Function to get the ASCII Character for a give ASCCI Code.
(03:48) See the CODE Function to get the ASCII Code for a give ASCCI Character.
(04:16) IF Function to put check mark in cell when number is greater than zero.
(05:32) Conclusion

WORKBOOKS

Download “Excel Magic Trick 1401-1405” Excel-Magic-Trick-1401-1405.zip – Downloaded 83 times – 1 MB







Be the first to comment

Leave a Reply