Error in expression: If takes 2-3 parameters

[#1]

I have a table with quite a few dimension and 3 expressions.

The result set is based on 3 list box. When I press clear I get this error message:

Error in expression:

If takes 2-3 parameters

However, if I choose details from the list box it works without any issue. If I choose all the entries from the customer list box which will essentially return all the values in the same way as pressing the clear button.

If I disable all the expressions the report doesn't run at all as I am using a straight table. As the error suggest it must be one of my expressions. Can you take a look and see if my expressions wont work using the clear function

1. Inv Qty -

=if([Item Code]  like('F*') and LinkId='INVHSTD' and [Sales Order Num]<> Null(),
[Inventory Free Quantity]+[Inventory Reserved Quantity],0)

2. Value-

= if (LinkId='INVHSTD' and [Sales Order Num]<> Null(),
  ([Sales Unit Price]*[Inv Qty])/[Sales Price Unit Conversion],0)

3.Value Display -

=if (isnull([Value]) and [Item Code]  like('F*'), [Inventory Free Value],[Value])

Any help would be gratefully received

[Sergey_Shuklin]

Hello, Dave!

And what this list box fields are?

[sunny_talwar]

Would you be able to share a sample to look at this?

[#4]

my list boxes are customer, sales rep and csr

[#5]

Sorry I can't...company policy. Madness I know