Home Search

DriveWorks Solo 21
IfErrorString

Send Feedback

IfErrorString

This function checks to see if its first argument is an error string. If the value isn't an error it is returned as-is, otherwise a replacement value is returned.

Syntax

IfErrorString([Primary Value], [Error Replacement Value])

Where:

Primary Value is the value to check for an error.

Error Replacement Value is the value to use if the primary value is an error.

Examples

RuleMeaning
IfErrorString(DWVariableName,"Please Enter a Valid Name")Will return Please Enter a Valid Name when the value coming from the variable Name is an error.
Error values that are checked include:
  • #NA!
  • #VALUE!
  • #REF!
  • #NUM!
  • #NAME?
  • #NULL!