How do I convert <error> value to something else like 07 followers
I am using GROUP_DIFF to get some value. But if there is only one row, I don't have a value, but get <error> in red font instead.
So I am trying to convert it to numeric value, but my method below did not work.
IF(T(#sheet1!B) == "<error>";0;INT(#sheet1!B))
What else can I do?