11 Replies Latest reply: Apr 30, 2015 11:04 AM by Neena Bhattarai RSS

    Two separate IF statements in one expression.

    Neena Bhattarai

      I have two separate IF statements I am trying to put into one expression in a straight table. It is only giving me back -1 and nothing else.

       

      My expression is:

      =IF([Payment Terms]='12',[Extended Amount]*0.02)

      OR

      IF([Bill To]='24973618' OR '24973619',[Extended Amount]*0.12)



      How can I make this expression work without having to make two separate columns for it. Any help is much appreciated.