About IF to change the bubble?

Options
hoangnh
hoangnh
edited 12/09/19 in Smartsheet Basics

i am doing this: 

- IF 0<(column2 / column1)<=0.9 then status is red.

- IF 0.9<(column2 / column1)<0.95 then status is Yellow.

- IF (column2 / column1)>=0.95 then status is Green.

- IF (column2 / column1) = 0 then status is blank.

I use this formula: =IF(0<[2]3/[1]3<0.9;"Red";if(0.9<=[2]3/[1]3<0.95;"Yellow";if([2]3/[1]3>=0.95;"Green";0)

but it doesn't work.

Pls help me

viber image.jpg

Comments