Hi
Can anyone tell me if it is possible to create a multiplication table where
you can change the table from multiplication to addition or division by
changing just one cell?
I have created the following formula where the values for A2 = 1 and B1 =1:

=A2&A1&B1

the problem I have is the value is read as a text string!!!

I have tried Indirect function and I have the same problem.

thanks in advance.

Tanya