What am I doing wrong ?!

[RvdHeijden]

Why wont this formula work ?

I need to change the format of a date value IF a certain value is not R40 or R41

[Anonymous · Accepted solution]

Hi, it looks to me like the syntax for OR() is incorrect. the OR function takes two logicals as the inputs so it should look more like

IF( OR( ADDRESSEN[...] = "R41", ADDRESSEN[...] = "R40"), result if true, result if false)

[RvdHeijden]

@Anonymous

you were right, i had to tweak the formula a bit but this one did the trick.

Civiel geplande datum = IF(OR(Adressen[R.N.A.]="R41";(Adressen[R.N.A.]="R40"));"";(Format(Adressen[civiel begin];"DD-MM-YYYY")))