Ask Your Question

Calc : EOMONTH does not show date.

asked 2019-08-17 11:30:23 +0200

lonk gravatar image

image description

Cell F2 → =IF(ISERROR(VLOOKUP(G2,$A$2:$B$21,2,0)),EOMONTH(DATE(E2,D2,1),0),VLOOKUP(G2,$A$2:$B$21,2,0))

Cell H2 → =EOMONTH(DATE(E2,D2,1),0)

Why cells in column F which are FALSE is blank ?

edit retag flag offensive close merge delete


Is there any reason to use IF(ISERROR(X);Y;X) instead of IFERROR(X;Y)?

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-17 11:34:20 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-08-17 11:38:39 +0200

It is unclear what seems wrong to you. In F2, a lookup is made in $A$2:$A$21 for the value in G2 (0000001), which is found in A2, and its corresponding B2 is returned (empty), not an error; so of course, the IFERROR returns FALSE, and then the "THEN" expression is not evaluated, but instead "ELSE" clause, which is the same VLOOKUP again, which returns an empty string, which you correctly see in F2.

edit flag offensive delete link more


@Mike Kaganski

I used this in MS Excel. Is that in LO different from in MS Excel ?

Can you please see this ?

lonk gravatar imagelonk ( 2019-08-17 12:20:18 +0200 )edit

@lonk: I don't understand your question. What is "different"? What I wrote above (both in my comment, and in my answer) is also true for Excel - but you need to elaborate in your questions: the link you provided above looks like you expect me to study that text carefully and understand in what part that contradicts with something I wrote?

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-17 12:49:16 +0200 )edit

@Mike Kaganski

Sorry for many comments.

I misunderstood.

ISERROR(VLOOKUP(G2,$A$2:$B$21,2,0)) searches for Staff ID, not the Resignation date.

It will give the result of 12/31/2019 for the ID in column G is not 0000001-0000020.

lonk gravatar imagelonk ( 2019-08-17 13:26:05 +0200 )edit

Yes, right! :-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-17 13:33:06 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-17 11:30:23 +0200

Seen: 13 times

Last updated: Aug 17