Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'am looking for a little simple thing : in a text box id'like to add a preceding + ou - sign depends my kpi is negative or positive. I want avoid condition (if KPI > 0, '+'&KPI Value....).
By default - sign appears when value is negative but no + when positive.
Any idea?
It could be reached just with a formatting like:
=num(YourNumber, '+ #.##0,00;- #.##,00')
- Marcus
It could be reached just with a formatting like:
=num(YourNumber, '+ #.##0,00;- #.##,00')
- Marcus