Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Mutiplication

microsoft.excel.training - Mutiplication

ResolvedVersion Standard

Tue 7 Aug 2007, 19:42 Delegate Stephen said...

Stephen has attended:
Project Intro Intermediate course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course

Mutiplication

Is there a fairly simple formula in Excel 2007 to create a mutiplication table, so whwt ever numbers I put in A2-A50 , this will mutiply by B1 - B50.
ie: A2xB1, etc

Wed 8 Aug 2007, 14:53 Trainer David said...

RE: Mutiplication

the problem i can forsee is that you will overwrite the contents of the cells in one group, however if you put the numbers you require in a2-a50, and b2-b50, then the formula in c2-c50 combining the a:b group, then you should be fine.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips

microsoft.excel.training - Mutiplication

Mutiplication

RE: Mutiplication

Excel articles

Excel tip:

Closing Multiple Workbooks quickly