Forum Discussion

Icon for Post Prodigy rank

Post Prodigy

9 years ago

Solved

What am I doing wrong ?!

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
9 years ago
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)

2 Replies

Anonymous
Not applicable
9 years ago
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
  Post Prodigy
  9 years ago
  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")))

Related content