undefined function

[SharonMee]

Hello all:

I have the following formula in the expression builder:
IIf([Delivery] Is Null,IIf([Cheque Status]="MAIL",WORKDAY([Check Date],3),[Delivery]))

But I am getting a "Undefined function "Workday" in expression"? Do you know why I am getting this error?

Thanks much.

SharonMee

 

[BNPMike]

From Help:

Some of the spreadsheet functions are provided through a separate dynamic link library file, Msowcf.dll. Search for Msowcf.dll on your computer, and if it's missing, either reinstall Microsoft Office 2000 or contact your system administrator.

Your IIF looks wrong.
IIf([Delivery] Is Null,
IIf([Cheque Status]="MAIL",WORKDAY([Check Date],3),[Delivery])no else value)