Download Files:
Part 1 https://excelisfun.net/files/EMT1402....
Part 2 and 3 Start https://excelisfun.net/files/EMT1402%...
Part 2 and 3 Finish https://excelisfun.net/files/EMT1402%...
Part 4
https://excelisfun.net/files/EMT1402%...
Part 5
https://excelisfun.net/files/EMT1405....
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:
1. (00:11) Introduction
2. (00:41) Insert a Symbol
3. (01:28) Generate full list of all 255 ASCII Characters using two tricks: 1) Rightclick 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.
4. (03:48) See the CODE Function to get the ASCII Code for a give ASCCI Character.
5. (04:16) IF Function to put check mark in cell when number is greater than zero.
6. (05:32) Conclusion