Search results
-
C
expression builder Iif not recognising text
=Sum(IIf([Details]="COST OF PRODUCT",[PerUnit]*[Quantity],0)) -
C
expression builder Iif not recognising text
That works perfectly: =Sum(IIf([Details]="COST OF PRODUCT",[PerUnit]*[Quantity],0)) Thank you- CJ81
- Post #3
- Forum: Modules & VBA
-
C
expression builder Iif not recognising text
Can anyone tell me what's wrong with this iif statement? =IIf([Details]="COST OF PRODUCT",[PerUnit]*[Quantity],0) it keeps coming back with 0 even when the text says COST OF PRODUCT I have also tried: =IIf([Details]="COST OF PRODUCT*",[PerUnit]*[Quantity],0) =IIf([Details] Like "COST OF...- CJ81
- Thread
- Replies: 3
- Forum: Modules & VBA
-
C
expression builder Iif not recognising text
Can anyone tell me what's wrong with this iif statement? =IIf([Details]="COST OF PRODUCT",[PerUnit]*[Quantity],0) it keeps coming back with 0 even when the text says COST OF PRODUCT I have also tried: =IIf([Details]="COST OF PRODUCT*",[PerUnit]*[Quantity],0) =IIf([Details] Like...