Results 1 to 6 of 6

Thread: help

  1. #1


    Member Since
    Nov 16, 2011
    Posts
    1
    Exclamation help
    i am using Numbers for the first time.

    i want a formula that will give me a product of 2 rows for each row in a table, varying values in each.


  2. #2

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,989
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    A product of 2 rows for each row... ???

  3. #3

    vansmith's Avatar
    Member Since
    Oct 19, 2008
    Location
    Toronto
    Posts
    19,741
    Specs:
    2012 13" MBP (2.5 i5, 8GB)
    Like toMACsh, I'm a little confused. This is how I understand it.

    Let's say you have this table:

    A B C
    1. VALUE VALUE XXXX
    2. VALUE VALUE XXXX

    As I see it, you're looking to do A1*B1 in C1, A2*B2 in C2, etc. Is that right?
    Important Links: Community Guidelines : Use the reputation system if you've been helped.
    M-F Blog :: Write for the blog
    Writing a Quality Post

  4. #4

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    5,989
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Quote Originally Posted by vansmith View Post
    Like toMACsh, I'm a little confused. This is how I understand it.

    Let's say you have this table:

    A B C
    1. VALUE VALUE XXXX
    2. VALUE VALUE XXXX

    As I see it, you're looking to do A1*B1 in C1, A2*B2 in C2, etc. Is that right?
    Is that what you meant?


    If that's what the OP means, then it's as simple as doing A1*B1 in cell C1, then using copy and paste for the succeeding rows. At least in Excel, the spreadsheet "translates" to the next row so it won't repeat A1*B1 but move on to 2, 3, 4, etc.

  5. #5

    vansmith's Avatar
    Member Since
    Oct 19, 2008
    Location
    Toronto
    Posts
    19,741
    Specs:
    2012 13" MBP (2.5 i5, 8GB)
    Quote Originally Posted by toMACsh View Post
    Is that what you meant?
    Yes it is, my bad.
    Important Links: Community Guidelines : Use the reputation system if you've been helped.
    M-F Blog :: Write for the blog
    Writing a Quality Post

  6. #6

    Sawday's Avatar
    Member Since
    Nov 19, 2006
    Location
    York, UK
    Posts
    1,210
    Specs:
    24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPad mini2, iPhone5s
    Birdcat - future reference... You'll get more response if you make a more meaningful title rather than just 'Help', even 'Help with Numbers' is better.
    Happiness is not getting what you want, but wanting what you get.

Thread Information

Users Browsing this Thread

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

Posting Permissions

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