About IF to change the bubble?

hoangnh

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

DanS

I suggest you use the conditional formatting feature, instead of a formula.

p_bureau

Hi! Could you try :

=IF( [2]3/[1]3>=0.95;"Green";IF( [2]3/[1]3>0.9;"Yellow";IF( [2]3/[1]3 >0;"Red";"")))

 

Best Regards,

 

Paul B

hoangnh

Thanks you guys, it's done!