I am working on a Google sheet that shows a sum that has been advanced to a customer and then shows the income per month the customer receives. We will retain 100% of the income until the amount that has been advanced is repaid.
I am trying to come up with two formulas for this spreadsheet which will work on each row:
- in column C that returns the first month that revenue is earned by the client and
- in column D that returns the number of months over which the client revenues pay back the advance listed in column B.
My research suggests that this is probably possible using an array function but I can't seem to find an example and don't understand the syntax enough to make it work.