Financial analysis: How to make calculation that meets certain condition with nested if statement

Hi all,   I have a financial calculation problem to ask and would appreciate any kind help! In the table below,  AA_100010 and AA_100020 are empty numbers. They are values from additions of other ...