IF formula or Nested IF

Tina

I'm trying to create a formula using the Flag symbol and a % Allocated to Project column.  I would like the flag to raise if the % Allocated to Project column is 50% or less.  If greater than 50% or Blank I would like the flag to stay down. 

I thought I could accomplish this with =IF([% Allocated to Project]@row< 0.5, 1, 0) however, the flag still raises when the field is blank.  

Any help would be appreciated!

 

Andrée Starå

Hi Tina,

Try something like this.

You need to add an IF for the blank value. I prefer the ISBLANK function.

=IF(ISBLANK([% Allocated to Project]@row); 0; IF([% Allocated to Project]@row < 0,5; 1; 0))

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

=IF(ISBLANK([% Allocated to Project]@row), 0, IF([% Allocated to Project]@row < 0.5, 1, 0))

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

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD