Formula help

dave.mcpherson56751

Hi,

I am working hard to get my head around formulas and have managed to get the correct return with the below formula, if greater than 14 days then return "Yes", if less than 14 days then return no. Where i am struggling is i also want to return "Yes" if the cell is blank.

current formula: =IF([Days since last clean]1 <= 14, "No", IF([Days since last clean]1 > 14, "Yes"))

Any help would be appreciated.

Thank you

Dave

Andrée Starå

Hi Dave,

Try something like this.

=IF([Days since last clean]@row = ""; "Yes"; IF([Days since last clean]@row <= 14; "No"; IF([Days since last clean]@row > 14; "Yes")))

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

=IF([Days since last clean]@row = "", "Yes", IF([Days since last clean]@row <= 14, "No", IF([Days since last clean]@row > 14, "Yes")))

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 week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting