The following initial situation:
I have numerical values in an Excel column. However, I would like to reformat them so that the possible range of values is discretised into 4 sub-ranges and a text is output instead of the concrete value. Only in the last sub-range should the number (#) be concatinated with additional text. That is:
] ∞, 0 [ => "Error"
[ 0 ] => "---"
[ 1 ] => "X"
] 1, ∞ [ => #"x"
Question:
Which pattern do I have to enter as type to achieve this required result?
Thank you very much for your help!
My current status:
So far I have read the official documentation and tried to orientate myself on its examples, but unfortunately without success. My last pattern looks like this:
[<0][red]"Error";[=0]"---";[=1]"X";[>1]#"x"
... but unfortunately this pattern is not accepted by Excel.