2 Replies Latest reply on Sep 24, 2015 8:32 AM by tml6175

    How to sum a series of if thens?

    tml6175

      Given:

      Image.jpg

       

      I need to sum (PM01) Receipt Cost Breakfast (Cost01), Receipt Cost Lunch (Cost02), and Receipt Cost Dinner (Cost03).

      If each Receipt Cost exceeds each Meal Allowance, then use Meal Allowance Value in sum.

      If each Receipt Cost is less than or equal to each Meal Allowance value, then use Receipt Cost in sum.