Accessdabbler
Technical User
Not sure the best way to explain this. Consider a row of numbers:
100 200 500 300 400
Now, in another cell I type the value "1000".
I want a formula that will subtract the first row of numbers, one-by-one from 1000 until the result is less than 0. In this case, the answer would be 4 since the formula had to go to the 4th number before the result was less than 0.
If it makes a difference, the numbers could be in a column instead of a row.
100 200 500 300 400
Now, in another cell I type the value "1000".
I want a formula that will subtract the first row of numbers, one-by-one from 1000 until the result is less than 0. In this case, the answer would be 4 since the formula had to go to the 4th number before the result was less than 0.
If it makes a difference, the numbers could be in a column instead of a row.