Answer the question
In order to leave comments, you need to log in
How to check for ERROR in CALC (open office)?
There is a formula:
VLOOKUP(C2;Sheet2.A$1:B$15;2;0;0)
must be checked for an error and output 0 in case of error or the result of the function in case of success.
In excel there is an ESLIOSHIBKA, is there an analogue in calc?
tried like this IF(ISERROR(VLOOKUP(C2;Sheet2.A$1:B$15;2;0));VLOOKUP(C2;Sheet2.A$1:B$15;2;0;0)) outputs "error:504"
question closed, found a typo
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question