Barry
Thanks for the information it helped but did not solve my problem.
Thank you

"Barry Gilbert" wrote:

It looks like you're missing an opening square bracket toward the end of the
statement.

Also, can PT1 ever be less than zero? If not, you can probably eliminate the
second IIF.

HTH,
Barry

"Roger Drews" wrote:

I am trying to write an IIf statement to use in a calculation where if PT1 is
zero it will use PC1 to determine the value. Here is the state I have tired
but I cannot get it to work. What am I doing wrong?
IIf([PT1]=0, [PC1]-[IC1], IIf([PT1]0,[PT1]-IC1])