If(And) #unpareseable error- help

karlinlh

Hi I am trying to write a formula to check values in two columns to set a flag on or off.  If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error.  Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1).

 

Any guidance would be appreciated,

 

Thanks,

Lisa

Andrée Starå

Hi Lisa,

Percent in formulas are written as 1 for 100%.

Try this.

=IF(AND([Planned Finish]@row > TODAY(); [% Complete]@row = 1); 0; 1)    

The same version but with the below changes for your and others convenience.  

=IF(AND([Planned Finish]@row > TODAY(), [% Complete]@row = 1), 0, 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

There is also the comma missing from the original formula after the AND statement.

 

=IF(And(...............), 0, 1)

                              ^