Help in Formula - Gauge Light

[#1]

Hi friends,

For display of traffic gauge lights, i am using the formula where

0 - Green

1-Amber

2-Red

=If((Column(3)/Column(2))*100 < '0%','0',If((column(3)/column(2))*100 > '0%' and (column(3)/column(2)) < '5%','1','2'))

But when the condition is 0%, it should show green but it is showing red.

Can someone help me with formula?

Regards,

KC

[jonathandienst · Accepted solution]

=If(Column(3) / Column(2) < 0 Or Column(2) = 0, 0,

  If(Column(3) / Column(2) < 0.05, 1, 2))

[#3]

Thanks all