Return Boolean (TRUE / FALSE)

[sharshra]

In a formula, I am using few functions. If any function returns a value, I want the function to return boolean TRUE instead of actual value. If it returns an error, I want boolean FALSE to be returned. How can this be done? Please advise.

For example, if XLOOKUP in a formula returns a value, I want this to be converted to boolean TRUE. If XLOOKUP returns #N/A, I want this to be converted to boolean FALSE.

 

[etaf]

IF(isna(xlookup(....)),FALSE, TRUE)

 

[hagia_sofia]

Or generally you could go with:

NOT(ISERROR(A1))

 

[sharshra]

Thanks, @hagia_sofia