Switch fails when result is 0

[abaer]

Thanks for that! To build up knowledge for everyone, I jogged up my memory and link posts from the past that had the same general topic (i.e. consistent data type as a formula result):

How to create a formula if the source column contains as result #N/A

I have a formula which contains positive and negative numbers, as well as " #N/A " as result. I want to create a additional formular as an ifs, which says ifs({Column A}>= 1, “OK”, {Column A}<= -1, “Not good”, {Column A}= “#N/A”, “Not available”) However “#N/A” is not recognized, how to express this result in a formula?

Why is this formula not working

Not wanting to have the last world or be right (because both solutions work), I’ll just add the knowledge I acquired in long, frustrating sessions to prevent others from the same fate in more complex scenarios: Both methods make sure that the column only contains values of one type (String). How I understand it, the format detection takes the data in the first row it encounters. I just made a quick test with a formula that creates number, date, boolean and string values. ifs( {Name}="A",True()…

That’s where I learned the hard way that consistent output data type is a good idea