IIF formula

[Rick]

I am trying to create a custome resource cost field which will calculate an
overhead only cost using a rate I input into the formula. All of our
resources have a catagory number which we enter into the "code" field on the
resource information. The formula below is what I have working so far.
IIf(

=7,([Baseline Cost]*0.14),0)
My problem is I also need the formula to look at the type field and
determine if it is = work.  Can anyone tell me what the formula would be?

 

[JimS]

Try
IIf([Type]=0,IIf(

="7",[Baseline Cost]*0.14,0),0)