comparison operator help

[mcbradford]

I know this is simple, but I just cannot get it.

 

Fields

 

UpperValue, LowerValue, EnteredValue, PassFail

 

If EnteredValue is between the range of UpperValue and LowerValue, "Pass", otherwise "Fail". If nothing entered in UpperValue, LowerValue or EnteredValue, "Null".

 

Thanks

[Maarten Witberg]

hi

passfail=
Case( not isempty(uppervalue) AND not isempty(lowervalue) AND not isempty (enteredvalue);
  Case(lowervalue<=enteredvalue AND enteredvalue<=uppervalue;"pass";"fail"
  )
)

 

kjoe

[mcbradford]

Case( not IsEmpty(UpperValue) and not IsEmpty(LowerValue) and not IsEmpty(TechValue),

Case(LowerValue

 

Tech Value = 425

Upper Value = 550

Lower Value = 450

 

Result = Fail

 

?????

[mcbradford]

oops - my eys are crossed - disregard :-(

[Maarten Witberg]

so you're ok then?

 

slightly shorter:

 

Case(uppervalue and lowervalue and enteredvalue;

Case(lowervalue

)

)

 

 

kjoe

[-Queue-]

If one of the values is zero, that one will not work.

 

Case( not (IsEmpty(uppervalue) or IsEmpty(lowervalue) or Isempty(enteredvalue));

Case( lowervalue

)

)

 

is probably the most compact you should make it.