Text() function.
I have column with price type.
This column is quoted and used in virtual columns in combination of other column to show new values.
To show $ as it is price, I use Text() function.
However, when the price is minus, it is show as ($xx,xxxx), instead of โ-$xx,xxxโ.
How can we show price value as " -$xx,xxx " in such a case?
#ERROR!
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |