I need a nested formula to pull a specific code type in a column. My transaction code field needs to pull AD, FY or RN = (Advances, First Year or Renewals). If the Earned/Advanced column has Advance, this automatically equals AD. If the Earned/Advanced column has Earned, this needs to be FY...