# Formula result displayed along with text symbol

#### jski21

##### New Member
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

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### Fluff

##### MrExcel MVP, Moderator
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

##### New Member
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

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback