kittymongo
New Member
- Joined
- Feb 6, 2018
- Messages
- 16
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 or RN depending on the date. Is there a nested formula I can use to pull this in one try? I have a work around using multiple columns but would be easier as one.
If the Effective Date is 365 days or less and the Earned/Advanced is Earned, this needs to read FY. If the Effective Date is over 365 days and the Earned/Advanced is Earned, this needs to read RN.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I hope I gave enough information here to figure this out? Please help.
If the Effective Date is 365 days or less and the Earned/Advanced is Earned, this needs to read FY. If the Effective Date is over 365 days and the Earned/Advanced is Earned, this needs to read RN.
Effective Date | Earned/Advanced | Trans Code |
07/13/2018 | Advance | |
05/01/2016 | Advance | |
09/22/2017 | Earned | |
10/31/2018 | Earned |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I hope I gave enough information here to figure this out? Please help.