Create a Table of Results

B

balhal

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 can’t 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 don’t do
anything)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top