Lab Value with iif function.

  • Thread starter Thread starter E-mail report using Lotus Notes rather t
  • Start date Start date
E

E-mail report using Lotus Notes rather t

Hi,

I am trying to use the iif function for laboratory values. Basically I have
lab value with number and alphabets. I want all the values with an alphabet
from A to Z to state "N" or negative and if it is a number value then leave
it as is (no change). Below is an iif function I am trying to create
maricles with. Please help. Thanks.

TEST: IIf([lab_value]=like"*[A-Z]*","N")
 
Hi,

I am trying to use the iif function for laboratory values. Basically I have
lab value with number and alphabets. I want all the values with an alphabet
from A to Z to state "N" or negative and if it is a number value then leave
it as is (no change). Below is an iif function I am trying to create
maricles with. Please help. Thanks.

TEST: IIf([lab_value]=like"*[A-Z]*","N")
Click to expand...

Try

IIf(IsNumeric([Lab_value], [Lab_value], "N")

Note that the IIF function takes *three* arguments - you gave it two - and
that the = operator and the LIKE operator are two different choices; you can't
use both together.
 
Back
Top