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