jski21
Board Regular
- Joined
- Jan 2, 2019
- Messages
- 133
- Office Version
- 2016
- Platform
- Windows
Good day Excelers,
Why would the text formula in C6 not show the correct percentage? Should be -24.3%. Instead, it shows 0.0%:
Thought I had everything right, but evidently not. Thanks.
jski
Why would the text formula in C6 not show the correct percentage? Should be -24.3%. Instead, it shows 0.0%:
Cell Formulas | ||
---|---|---|
Range | Formula | |
C3 | C3 | =((B2-B3)/(A2-A3))-1 |
C6 | C6 | =TEXT((ROUND((B2-B3)/(A2-A3),0)-1),IF((B2-B3)/(A2-A3),"0.0%")&""&IF((B2-B3)<(A2-A3),"▲",IF((B2-B3)=(A2-A3),"●","▼"))) |
Thought I had everything right, but evidently not. Thanks.
jski