I sometimes want a function that returns some value if the result is blank, and the result itself function otherwise.
=IF(FUNCTION()="","WAS BLANK",FUNCTION()) works, but I hate the duplication.
With functions returning numbers I came up with a hacky solution using iferror
This is really useful to me, but I'm wondering if there's something similar I can do for functions which return text.
I do this to avoid UDFs/helper columns/duplication