Help with "IIf

  • Thread starter Thread starter Alberta Rose
  • Start date Start date
A

Alberta Rose

Could anyone help me with this formula? I need to know where to put the
coding that if there is no value in the selected txt's to return a zero.

=IIf([costcode]="013210" And [costtype]="05320",
[txtEstimatedCost]/[txtCraftLabEst], IIf([costcode]="020110" and
[costtype]="05320",[txtEstimatedCost]/[txtFirewatchLabEst],
IIf([costcode]="064201" and [costtype]="05320",
[txtEstimatedCost]/[txtCraftSuprLabEst],Null)))
 
Back
Top