Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can someone tell me what's wrong with the following expression:
if([Test] < '3', green(), if([Overall Risk Value] >= 3 and <= 5.5, Yellow(), Red()))
Thanks in Advance,
-Lenny
if([Test] < '3', green(), if([Overall Risk Value] >= 3 and [Overall Risk Value] <= 5.5, Yellow(), Red()))
Crrect expression
if([Test] < '3', green(), if([Test] >= 3 and <= 5.5, Yellow(), Red()))
if([Test] < '3', green(), if([Overall Risk Value] >= 3 and [Overall Risk Value] <= 5.5, Yellow(), Red()))
if([Test] < '3', green(), if([Test] >= 3 and [Test]<= 5.5, Yellow(), Red()))
Thank you it worked.