Define a sheet as a function

I have a sheet. If i write a number in one cell, the sheet will output a different number in a different cell after doing a lot of calculations.

I want to get the output for a lot of different numbers, for example 1 to 1000, but without having to type in 1, 2, 3 etc and write down the output. How can I achieve this?

Did you study the help page concerning “muiltiple operations”?

Sheet - Fill Cells - Series… ?

You need select the target cell range before…