Continue the calculation but stops at 99 *

[DocAElstein]

Ok, I did that and that's wonderful but how can I change the spreadsheet so I don't have to keep dragging it down? Is that possible? I thought that what the "limit" entry is suppose to do automatically. Isn't it?

You could do that with a VBA Code.
But that is realy trying to run before you can walk.
Can you not just drag the formulas a long way down so that there is always enough. ?

The "limit" entry is just a value used in the formula.
The formulas give you no value ( "" ) or a value based on an equation depending on If the the condition is met
https://support.office.com/en-us/art...c-aa8bbff73be2