1

Let's consider any (potentially lengthy) function that can produce an error. For discussion's sake, I'll use =1/0. I can ignore the resulting error by using the following formula:

=IF(ISERROR(1/0),"",(1/0))

As you can see, the function (e.g. 1/0) is typed twice. Is there a neater way to do this?

Improve this question
6
  • Are you trying to igore errors or are you trying to avoid writing a lengthy function multiple times?
    – Reddy Lutonadio
    Commented Oct 16, 2020 at 6:37
  • @ReddyLutonadio Both. For efficiency's sake, I want to avoid repeating code.
    – t185ish4wx
    Commented Oct 16, 2020 at 6:55
  • Only in LibreOffice? Or also Excel?
    – Reddy Lutonadio
    Commented Oct 16, 2020 at 6:59
  • I am working in LibreOffice. I tagged Excel since I imagined the Q&A would be similar, if not identical.
    – t185ish4wx
    Commented Oct 16, 2020 at 7:02
  • With Excel, if you have Office365, you can use the LET function. I am not sure that LibreOffice Calc has an equivalent function.
    – Reddy Lutonadio
    Commented Oct 16, 2020 at 7:04

1 Answer 1

Reset to default
1

A user on another forum found the answer:

Hello,

check function IFERROR(): In your example it would read: =IFERROR(1/0;"")

See also: LibreOffice Help - IFERROR

Hope that helps.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .