Formula to compute increase or decrease and include symbol for up or down

[howard]

I have inserted symbols in S1 & T1 to indicate in increase (up) or decrease (down) . Have used the up nd down arrow using Wingdings 3


I have set up a formula to compute the increase or decrease and to include the increase symbol (up sign) and decrease 9down sign) at the end of the formula but the result is for eg 114.45p. the resul should be for eg 114.5 followed by the up arrow symbol as it is positive

when pasting the data over here, the up and down triangle arrow is not displaying

Book1
	S	T
3	p	q
Sheet1

The formula I have used is

=IF((B2/C2)-1>0%,TEXT((B2/C2)-1,"#,#0.00%")&S1,TEXT((B2/C2)-1,"#,#0.00%")&T1)&""

Book1
	B	C	D	E
2	(185)	(149)	(36)	24.16%p
Sheet1

Cell Formulas
Range	Formula
D2	=+B2-C2

your assistance in resolving this is most appreciated

 

[Yongle]

Try this instead

Up arrow
=UNICHAR(8593)
Down arrow
=UNICHAR(8595)

I have not tested your formula, but assuming it is correct, then
=IF((B2/C2)-1>0%,TEXT((B2/C2)-1,"#,#0.00%")&S1,TEXT((B2/C2)-1,"#,#0.00%")&T1)&""
becomes
=IF((B2/C2)-1>0%,TEXT((B2/C2)-1,"#,#0.00%")&UNICHAR(8593),TEXT((B2/C2)-1,"#,#0.00%")&UNICHAR(8595))&""

 

[howard]

Thanks for the help, Unichar code works perfectly

 

[howard]

Is there a way to format the data so that the arrow is in the far right after the % for eg 161.45% ?. The arrow then to appear on the far right of cell where this % is