12 Replies Latest reply on Dec 7, 2018 5:15 PM by Toby Erkson

    Help with IF Statement to check balances

    Nancy Ratwatte

      I need help to write an IF statement to calculate if the transaction amount equals either the quarterly, monthly, semi annual or annual prem then minus that amount and give a balance.  If it doesn't match either of those columns then put the transaction amount as a difference?