Can you generate a table in Excel without using a Macro, Pivot Table or VB?
A1 has a user input. B1 = 3*A1. I want to create a table as follows

Input Result
2 6
3 9
-4 -12

I suspect you can use one of the pointer functions to tell Excel where to
store the next result, but I cant figure out how to do that €“ is there
something equivalent to a STORE command.

Another thought is to have the table cells check the user input to see if
the result should be stored there. For example, the user inputs the table row
value along with the input ; then for each row in the table to be generated,
have a command that accomplishes the following:

if(table row is me, then put the input and result here, else dont do
anything)