+ Reply to Thread
Results 1 to 6 of 6

Multiplication formula

  1. #1
    Registered User
    Join Date
    03-05-2007
    Posts
    3

    Multiplication formula

    Howdy, im looking for a single formula that will do

    1 2 3 4 5 6 7 8
    2 4
    3..9
    4....16
    5........25
    6........... 36
    7
    8

    so on and so fourth, except with 10s

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,854
    Assuming your values are in A1:A8, and across the top through H1 (as your example shows), in B2 put the formula exactly as shown:

    =B$1*$A2

    You can then fill this down as many rows as you need using the fill handle. Once that column is filled, and with those cells still selected, you can easily fill all columns to the right by dragging that direction with the fill handle.
    Last edited by Paul; 03-05-2007 at 01:03 AM.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,323
    You want a formula that will build the table by multiplying the heading to each row by the heading to each column?? That's pretty easy, though I apologize for using R1C1 notation; I've grown quite accustomed to it. =rc1*r1c copied through the table. What's the equivalent A1 notation: B$1*$A2??

    If that's not what you want, then can you explain better what you want?

  4. #4
    Registered User
    Join Date
    03-05-2007
    Posts
    3
    My teacher has set a little task to make a multiplication table using just 1 formula, the above posts arnt it, thanks anyway though. any ideas for different ways to do it ?

  5. #5
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,854
    If you want ONE formula that will cover every cell, this might work:

    =COLUMN()*ROW()*100

    This assumes that down column A you have

    A1=10
    A2=20
    A3=30
    ...

    And across the columns you have

    A1=10
    B1=20
    C1=30
    ...

    Put the formula in B2 and fill down and across. This will create your multiplication table by 10's.
    Last edited by Paul; 03-05-2007 at 01:26 AM.

  6. #6
    Registered User
    Join Date
    03-05-2007
    Posts
    3
    thanks alot.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1