I have a spreadsheet with two columns of numbers. I'm trying to identify growth in column "B' and specify when the value in column "B" stops rising. (IE: cell "B4<B3"). When this happens, I want to return difference between the cell that ended the rising trend ("B4") and the cell in the adjacent column where the rising trend began ("A2"). I've highlighted specific values that correspond to the requirements i'm asking for.
I want to return a "0" for when neither of these requirements are met.
Bookmarks