sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
In cell A1 I have a formula which comes up with either 0 or a number greater than 0.
In cell B1 I want:
1. A tick symbol to appear if A1=0
2. A cross symbol to appear if A1 >0
Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas?
Can this be done?
In cell B1 I want:
1. A tick symbol to appear if A1=0
2. A cross symbol to appear if A1 >0
Not sure how to do it or what formual would allow this as I have never dealt with symbols in formulas?
Can this be done?