IF is Integer?
I have a formula column that is constantly changing and bringing in live information. If the numbers are integers, I want to see them rounded with no decimal point. If the numbers do have decimals, I want to see only 1 decimal place. Pressing the increase/decrease decimal button doesn't help, since I need it to depend on if the number is an integer or not.
For example, I want to see the cells on the left column in the picture, not the ones on the right:
These cells are live and always changing so I can't use the increase/decrease decimal buttons.
Can I use the INT function for this? Or do I need to do something fancy with RIGHT and LEN?
Help Article Resources
Check out the Formula Handbook template!