How do I set up a multiplication table using formulas?
I think this way is probably better for the teaching part of his request.
While Paul's is a slick way of doing it for a 'general' case, it would not
show the students how Excel is taking values from different locations and
manipulating them to come up with useful information. Your method does - can
change a value in either the x or y axis and visually show the results of the
change.
"JMB" wrote:
Another way
=B$1*$A2
copy across and down
"Bruce" wrote:
I am trying to demonstrate the usefulness of Excel by showing my kids how it
will calculate multiplication tables for them. Using numbers 1 to 12 (for
example) across the x-axis and 1 to 12 across the y-axis would yield a
product. Any assistance in using formulas?
--
Bruce Schmidt
|