bmenendez

Nested If Statement Question

Discussion created by bmenendez on Jan 24, 2017
Latest reply on Jan 24, 2017 by keywords

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

Outcomes