Text Formatting with Symbols

[jski21]

Good day Excelers,

Why would the text formula in C6 not show the correct percentage? Should be -24.3%. Instead, it shows 0.0%:

Book1
	A	B	C
2	1,681,212	1,452,242
3	991,453	930,115	-24.3%
4
5
6			0.0%▲
Sheet1

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

 

[steve the fish]

Change the ,0 in the round to ,3

 

[Fluff]

Why would the text formula in C6 not show the correct percentage?

Because your rounding it to 0 decimals, which results in a value of 1, you then subtract 1 which gives 0

 

[Joe4]

You need to remember that percents are really decimals, i.e.
24.3% is really .243, so you need to round to 3 decimals.

 

[jski21]

Thanks for the second set of eyes gentlemen. Been staring at this 5-taber for a while and this was helpful.

 

[Fluff]

Glad we could help & thanks for the feedback.