M
M
Maxim Timofeev2016-06-13 15:06:56
excel
Maxim Timofeev, 2016-06-13 15:06:56

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

1 answer(s)
R
rosperitus, 2016-06-14
@rosperitus

IFERROR, IFNA

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question