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

User Talk Formulas
1

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?

2

Seatable uses the first rows to determine the result type. In your case, Seatable probably recognises the formula results as numbers. If the result type is number, N/A is not a valid value and hence not displayed. (In a number column, string are not shown either.)

3

So can I make a formula, which returns not valid values?

4

I think your problem can be solved if we add an iserror() function.

5

This would be awesome!

6

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.