98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Mutiplication
microsoft.excel.training - Mutiplication
Resolved · Low Priority · Version Standard
Tue 7 Aug 2007, 19:42Delegate 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:53Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:New Normal WorksheetDo you want all your worksheets to confirm to a certain look? Then change the Defaults!!! |
