In the image below the yellow cell is a number that I am trying to get a monthly payment for. Here are the calculations that I need in the following cells.
AA: Will be manually typed
AB: Will be manually typed
AE: Will be manually typed
I need these calculations to only show up to the right of the yellow cells (or Y cells that have a number in them but the X just to the left is blank).
I hope this isn't too confusing. Thanks!