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

    Using IF to determine which sum to use

    Natalie Mahoney



      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.