Q. How can I set up my Excel to repeat a formula for 1000 columns?

Hmm. I'm not good at either math nor Excel. My suggestion is to go to YouTube. Try this search: [excel how to repeat formula in cells] without the brackets. Several results looked promising and you won't have to waste a lot of time. Most looked like they were five minutes or less. I hope that helps. If not, try varying the terms in the search above.