Thanks all. I confirm that I see the Err:522 and Err:504 on your respective bug examples. My particular spreadsheet was hitting the Err:504, but when I tried to create a simple reproduction I encountered the Err:522 as well.
In the meantime until these bugs are fixed, I’m wondering if a macro function could be a workaround? It seems like a macro should be possible to do a similar operation correctly, essentially filling in 2 input cells with some values and then copying the output cell to another cell, then repeating a certain number of times.