Showing a value and a symbol in the same cell

[#1]

Hello everyone,
Could you please help me to "show a value and a symbol in the same cell" similiar as below;

[settu_periasamy]

Hi,

If you want just a symbol to add with your data, you can try like this..

=if(sum(Data1)>=10,'▲ '&sum(Data1),'▼ '&sum(Data1))

[jonathandienst]

A cell can either display a text or an image, not both -- the representation applies to the whole cell. You could modify the table style to exclude the vertical lines between cells (Properties | Style), or you can use graphical characters like the previous post.

[jonathandienst]

[#5]

Thank you so much for answering, but I can not open the file that you send.
Could you please send me the code, you wrote in the edit scipt?

[settu_periasamy · Accepted solution]

In Script just Inline Load..

LOAD * INLINE [
     Check, Data1, Data2
    A, 6, 9
    B, 11, 15
    C, 10, 15
    D, 4, 18
    E, 8, 6
];

Straight Table:

Dimension : Check

Expression :    =if(sum(Data1)>=10,'▲ '&sum(Data1),'▼ '&sum(Data1))

Text Color :     =if(sum(Data1)>=10,Green(),Red())