Complex IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am trying to create a formula to calculate a value based on 3
different criteria. This is an example of what I have, the third criteria is
that if the value is null, to return "", but I can't get it. Thanks in
advance.

Expr1:
IIf([FinishedTDS]<=100,([FinishedTDS]*0.0007)+9.7,([FinishedTDS]*0.0006)+9.77)

Rick Whittet
Water Quality Analyst
 
Hello, I am trying to create a formula to calculate a value based on 3
different criteria. This is an example of what I have, the third criteria is
that if the value is null, to return "", but I can't get it. Thanks in
advance.

Expr1:
IIf([FinishedTDS]<=100,([FinishedTDS]*0.0007)+9.7,([FinishedTDS]*0.0006)+9.77)

Rick Whittet
Water Quality Analyst
Click to expand...

IIf(IsNull([FinishedTDS]),"",IIf([FinishedTDS]<=100,([FinishedTDS]*0.0007)+9.7,([FinishedTDS]*0.0006)+9.77))
 
Thanks Fred, I appreciate your help.
--
Rick Whittet
Water Quality Analyst


fredg said:
Hello, I am trying to create a formula to calculate a value based on 3
different criteria. This is an example of what I have, the third criteria is
that if the value is null, to return "", but I can't get it. Thanks in
advance.

Expr1:
IIf([FinishedTDS]<=100,([FinishedTDS]*0.0007)+9.7,([FinishedTDS]*0.0006)+9.77)

Rick Whittet
Water Quality Analyst
Click to expand...

IIf(IsNull([FinishedTDS]),"",IIf([FinishedTDS]<=100,([FinishedTDS]*0.0007)+9.7,([FinishedTDS]*0.0006)+9.77))
Click to expand...
 
Back
Top