this it’s not correct? why?
=if(“exited”=“entered”,“Arrived at work”,“Left work”)
You will always get Left work result with this formula. “exited”=“entered” test condition will always return False. What is your goal?
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”)
why i receive this answer: “err505”
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!?
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.
My assumption is that your parameter separator is not , comma but maybe ; semicolon instead.