Problem with and IIF statement

[Skip Bisconer]

I can't seem to get this to work. I am trying to force ListMargin to 0 if Cost or Sell is 0. This is the statement I am trying to use. It gives me an Undefined functin 'IFF' in expression error.It's quite possible I am misinterpeting MS Help. I would apprecate someone setting me right. I get my 0 if I just use the divisor less than one but I am curious as to why this expression doesn't work.

ListMargin: IIf([InventoryList]<1,0,IFF([InventoryCost]<1,0,([InventoryList]-[InventoryCost])/[InventoryList]))

 

[pbaldy]

It's IIF, not IFF.

 

[Skip Bisconer]

Thanks Paul
We have had 75 degree weather for the last two weeks. Finally have some clouds today.

 

[pbaldy]

Yeah, it's been in the 50's here which is pretty balmy for January. They don't think these clouds are going to do much, if anything, unfortunately.