16 Replies Latest reply: May 4, 2018 5:20 AM by Chris Porthouse RSS

    Using IF to determine which sum to use

    Natalie Mahoney

      Hi,

       

      I'm trying to use an if statement as I would in Excel, but not getting anywhere. This is my formula. They are all numeric fields.

       

       

      IF(([Total Amount]*[Exchange Rate])=0,[Total Amount],[Total Amount]*[Exchange Rate])

       

      Does anyone have an idea please? I'm using classic.

       

      Thanks

      Natalie