Formula result displayed along with text symbol

jski21

New Member
Joined
Jan 2, 2019
Messages
17
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
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
36,143
Office Version
365
Platform
Windows
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
Joined
Jan 2, 2019
Messages
17
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
Joined
Jun 12, 2014
Messages
36,143
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,090,452
Messages
5,414,615
Members
403,536
Latest member
JEduardo

This Week's Hot Topics

Top