help

Joined
Nov 16, 2011
Messages
1
Reaction score
0
Points
1
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.

:\
 
Joined
Jul 30, 2009
Messages
7,295
Reaction score
301
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
A product of 2 rows for each row... ???
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
Like toMACsh, I'm a little confused. This is how I understand it.

Let's say you have this table:

No code has to be inserted here.

As I see it, you're looking to do A1*B1 in C1, A2*B2 in C2, etc. Is that right?
 
Joined
Jul 30, 2009
Messages
7,295
Reaction score
301
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
Like toMACsh, I'm a little confused. This is how I understand it.

Let's say you have this table:

No code has to be inserted here.

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.
 
Joined
Nov 19, 2006
Messages
1,774
Reaction score
81
Points
48
Location
York, UK
Your Mac's Specs
iMac: 5K 27” (2020), 3.3 GHz, 32Gb RAM. iPad2, iPad mini4, iPhone 13 Mini, Apple Watch SE
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.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top