| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
basic opertors
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Basic Chart | Charts and Charting in Excel | |||
| Really basic help with a graph | Charts and Charting in Excel | |||
| this is probably very basic | Excel Discussion (Misc queries) | |||
| Basic If | Excel Worksheet Functions | |||
| DV basic help | New Users to Excel | |||
Threaded Mode
