Formula returning dynamic values from an array works in excel, but not in VBA
I’m having an issue with a formula that I wrote in excel to take a negative number in a column (in this case, M10), and find a positive number that can absorb it without going below 0. (ex. 10 + (5) = 5).