Lab Value with iif function.

[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")

 

[John W. Vinson]

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")

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.