Formula result displayed along with text symbol

[jski21]

Is it possible to have the following formula display thedifference between cell C15 and another cell?

=TEXT(ROUND(C15,0),IF(C15,"#,##0","0")&""&IF(C15>C28,"▲",IF(C15=C28,"●","▼")))

The formula is useful as it shows the value of a designated cellalong with a symbol indicating whether the value is higher, lower, or the sameas another cell. I’d like it to display the difference between cell C15 and cellC28. I’m thinking the answer is no as as it’s displaying a cell value alongwith a text symbol.

Thanks in advance for the consideration and help.

jski

 

[Fluff]

You could use
=TEXT(ROUND(C15,0)-ROUND(C28,0),IF(C15,"#,##0","0")&""&IF(C15>C28,"▲",IF(C15=C28,"●","▼")))
Although it won't be a number
another option would be to do the calculation in the cell & use conditional formatting to add the symbol

 

[jski21]

Thanks Fluff. This is perfect.

jski

You could use
=TEXT(ROUND(C15,0)-ROUND(C28,0),IF(C15,"#,##0","0")&""&IF(C15>C28,"▲",IF(C15=C28,"●","▼")))
Although it won't be a number
another option would be to do the calculation in the cell & use conditional formatting to add the symbol

 

[Fluff]

You're welcome & thanks for the feedback