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
    6,146
    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,782
    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
    6,146
    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,782
    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,282
    Specs:
    iMac: 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.
    Experience teaches you to recognise a mistake when you make it again.

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
  •