12 Replies Latest reply on Jan 24, 2017 2:34 PM by keywords

    Nested If Statement Question

    bmenendez

      Hi All,

          Need some advice, as I tried to develop my statement based on the nested IF post I found but it doesn't seem to do anything. All I want it to do is fill in a field with an account number based on another fields choice...

       

      If ( Charge_To = "Royalty Advance: Trade Items"; Account_Nbr = "1-10-10-1350-000-0000-00";

      If ( Charge_To = "Royalty Advance: Parish Items"; Account_Nbr = "1-10-10-1350-000-0000-00";

      If ( Charge_To = "Work for Hire: Trade Items"; Account_Nbr = "1-10-10-4100-000-1010-00";

      If ( Charge_To = "Work for Hire: Parish Items"; Account_Nbr = "1-10-10-4100-000-1015-00";

      If ( Charge_To = "Work for Hire: CPKH"; Account_Nbr = "1-10-10-4100-000-1020-00";

      If ( Charge_To = "Work for Hire: Pamphlets"; Account_Nbr = "1-10-10-4100-000-1025-00";

      If ( Charge_To = "Work for Hire: Early Ch"; Account_Nbr = "1-10-10-4100-000-1030-00";

      If ( Charge_To = "Work for Hire: VBS for Curriculum"; Account_Nbr = "1-10-10-4100-000-1035-00"))))))))

       

      thanks for taking a look and letting me know what i did wrong lol.

       

      Brad