Ask Your Question

error in calc: what's wrong?

asked 2019-02-16 08:43:26 +0200

uzzituzzi gravatar image

this it's not correct? why? =if("exited"="entered","Arrived at work","Left work")

edit retag flag offensive close merge delete


You will always get Left work result with this formula. "exited"="entered" test condition will always return False. What is your goal?

SM_Riga gravatar imageSM_Riga ( 2019-02-16 10:34:09 +0200 )edit

4 Answers

Sort by » oldest newest most voted

answered 2019-02-16 10:57:17 +0200

JohnnyG gravatar image

As per the first answer not sure what you are trying to achieve. As is the formula will always return “Left Work”. If “exited” is a named range on your sheet which is updated with “entered” or something else when not at work then remove the quotes from around entered in the formula ie =if(exited=”entered”, “Arrived at work”, “Left Work”)

edit flag offensive delete link more

answered 2019-02-17 15:49:58 +0200

uzzituzzi gravatar image

why i receive this answer: "err505"

edit flag offensive delete link more


Are you using LibreOffice or OpenOffice Calc?

In OpenOffice, Calc error 505 is "Internal error", but (according to the latest online and offline help) LibreOffice has no Calc error code 505!?

BigRAl gravatar imageBigRAl ( 2019-02-18 16:02:17 +0200 )edit

There was an error code 505 but unused since ages and hence removed since quite some while. Please state your LibreOffice version. Error 505 was errIllegalJump so that might be related to the IF()

Also, please don't add additional information as answer, which it is not, edit the question instead. Thanks.

erAck gravatar imageerAck ( 2019-02-18 18:23:42 +0200 )edit

answered 2019-02-18 18:24:42 +0200

erAck gravatar image

My assumption is that your parameter separator is not , comma but maybe ; semicolon instead.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-16 08:43:26 +0200

Seen: 118 times

Last updated: Feb 18 '19