Hi,

I have the following IIf statement;

MarkupCost1: IIf([Markup]='',([Markup]*[GBPCost]),[PSP])

What am trying to do is if the [Markup] is blank then show the [PSP] value, but if the [Markup] is not blank then do the calculation ([Markup]*[GBPCost]).

The above IIf shows the [PSP] value when there is no data in [Markup] but when I enter data I get #Error in [MarkupCost1].

What am I doing wrong.
Thanks
Karl

MarkupCost1: IIf([Markup] & ""=''",([Markup]*[GBPCost]),[PSP])

MarkupCost1: IIf(Trim([Markup] & "") <> "",([Markup]*[GBPCost]),[PSP])

Or

MarkupCost1: IIf(Not IsNull([Markup]),([Markup]*[GBPCost]),[PSP])

Or

MarkupCost1: IIf([Markup] Is Not Null,([Markup]*[GBPCost]),[PSP])

First example deals with fields that are blank but are not null

2nd & 3rd handle Null values only. Field could be empty but not null

Thanks

They worked great....

Glad it's sorted.