Calc error 509
Solved
Hello everyone,
My question concerns a date difference. (
What I would like to obtain, see the attached file, is that in column F, the difference between the appointment date in E6 and today's date in E2, if this difference is less than or equal to 8, it should return 1 and otherwise 0.
When I enter this formula = if(E6-E2)<=8;1;0) it gives me ERR: 509.
What am I doing wrong? Maybe the parentheses?
Could you please help me?
Thank you in advance for your always numerous responses.
Best regards
Soubisien
My question concerns a date difference. (
What I would like to obtain, see the attached file, is that in column F, the difference between the appointment date in E6 and today's date in E2, if this difference is less than or equal to 8, it should return 1 and otherwise 0.
When I enter this formula = if(E6-E2)<=8;1;0) it gives me ERR: 509.
What am I doing wrong? Maybe the parentheses?
Could you please help me?
Thank you in advance for your always numerous responses.
Best regards
Soubisien
2 answers
-
ContributorHello,
you have 1 opening parenthesis for 2 closing ones.= if((E6-E2)<=8;1;0)
or
= if(E6-E2<=8;1;0)
or:=--(E2-E6<=8)
eric
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, yes, it happens!!!), remember to mark it as resolved. Thank you
