Ask Your Question
0

error in calc: what's wrong?

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

uzzituzzi gravatar image

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

edit retag flag offensive close merge delete

Comments

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 +0100 )edit

4 Answers

Sort by » oldest newest most voted
0

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

erAck gravatar image

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

edit flag offensive delete link more
0

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

uzzituzzi gravatar image

why i receive this answer: "err505"

edit flag offensive delete link more

Comments

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 +0100 )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 +0100 )edit
0

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 79 times

Last updated: Feb 18