AnsweredAssumed Answered

Small Coding Problem

Question asked by jrih on Apr 7, 2011
Latest reply on Apr 11, 2011 by philmodjunk

Title

Small Coding Problem

Post

I am going crazy trying to figure this out.  Numbers 1, 2 and 4 work perfectly, but 3 just comes up blank when I enter data within the parameters.  Can anyone help me.  I'm sure it is something simple.

Thank you.

If(LT < 94 and DB > 100 and RE = "NIL", "4", If((LT >= 94 and LT <= 149) and (DB >= 51 and DB <= 100) and RE = "SLOW", "3", If((LT >= 150 and LT <= 200) and (DB >=  21 and DB <= 50) and RE = "MEDIUM", "2", If(LT > 200 and DB <= 20 and RE = "FAST", "1", "" ))))

Outcomes