Expression help

[surfdog]

I am having trouble with this expression. Instead of caculating, it is reporting the wording in the expression. I am a newbie would appreciate help with correcting the expression.

=IIf([LINE_ITM_UOM]="ME",=[LINE_ITM_QTY_ORDRD]*1.094*2/3000,=[LINE_ITM_QTY_ORDRD]*2/3000)

 

[Sohaila Taravati]

Why do you have "=" everywhere? I got rid of the = sign in your code, maybe it will work for you.

=IIf([LINE_ITM_UOM]="ME",[LINE_ITM_QTY_ORDRD]*1.094*2/3000,[LINE_ITM_QTY_ORDRD]*2/3000)

Sohaila

 

[State]

Try this (remove the last two "="):

=IIf([LINE_ITM_UOM]="ME",[LINE_ITM_QTY_ORDRD]*1.094*2/3000,[LINE_ITM_QTY_ORDRD]*2/3000)

Let me know if this helps.

Paul

 

[surfdog]

Thanks all.
One last question, How do you get the answer to round up to the nearest interger?