Weight Cost TI: IIf([Sheet1.Manifest] Like "TI*",IIf([lbs]<1000,[lbs]*0.28,IIf([lbs]>1000,[lbs]*0.22,IIf([lbs]>5000,[lbs]=1100,0)))))
How can I force this IIf function to return a 0.00 cost if the Like is not met? I have tried the NZ function but have not had good results if the Like function is met.
Thanks,
Nick