Formula Logic

[jenneckelm]

Trying to get a formula written that changes the account code in column L to a specific code based on System Account Column AG, and Line Date Column AC. 

If the Journal date (column J) is > than Line Date (column AC) , and System Account (column AG) = FMLI_CO_ER then account should update to 111954. 

Thanks in advance for the help! 

[alexnajm]

IF [Journal Date]>[Line Date] AND [System Account] = "FMLI_CO_ER" THEN 111954 ELSE [Account] ENDIF

[alexnajm]

The above assumes the Journal Date and Line Date are stored as Dates, and you want the Account to be numeric - if the account should be a string, you would do: IF [Journal Date]>[Line Date] AND [System Account] = "FMLI_CO_ER" THEN "111954" ELSE [Account] ENDIF

[nagakavyasri]