Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am trying to attribute symbols (up/down triangle) when formatting a number with the num() function. I mange to get the correct values (333%) when I place the chr() symbols before the format type, but not when I place them after (I get 3%). I don't seem to find what's wrong and the correct nomenclature. May someone shed a light and help here, please? Can check this on my example below. Thank you!
Not sure why it behaves this way, but a work around
=num(10*100/3, '##0%' & CHR(9650) & ';' & '##0%' & CHR(9660))
Not sure why it behaves this way, but a work around
=num(10*100/3, '##0%' & CHR(9650) & ';' & '##0%' & CHR(9660))
Hi,
Have you tried like this?
=Num(10/3,'▲ #,##0;▼ #,##0')
and add your text color expression as
if(10/3=1,Green(),Red())
My issue is that I want the symbols before not after the format type
Did you look at what I provided?
Strangely it works yeah . I thought it wasn't gonna work because in my real cases it ended up giving me 0 as a value, but apparently multiplying by 100 makes it return the correct value again.
Any idea if the format can be extended to evaluate null values?
What do you mean, can you elaborate?
Ah nevermind, it didn't make sense what I was thinking. For a sec I totally forgot about the Null Symbol in Presentation tab.