Sub4Sub network gives free YouTube subscribers
Get Free YouTube Subscribers, Views and Likes

Excel Magic Trick 1402: Formula to Put Check Mark In Cell If Number Greater Than Zero

Follow
excelisfun

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

posted by DeseHeseiz