If I wanted to have three columns labeled x, y, & z and the fourth column be the surface area, with the formula being =2xy+2xy+xz, how would I enter it into excel? Is that even possible?
2007-06-04 07:30:36 · 6 answers · asked by Emily N 2 in Computers & Internet ➔ Programming & Design
RichLeick's response is wrong. The correct formula is
=2*A1*B1+2*A1*B1+A1*C1
Supposing that x, y and z are in cells A1, B1 and C1 respectively.
Nelson Bittencourt
See more in my site:
http://www1.webng.com/nbittencourt/index_e.htm
2007-06-04 09:29:16 · answer #1 · answered by nbittencourt 3 · 0⤊ 0⤋
occasion =SUM(A1-B1) then hit enter to adapt to any table purely exchange A1 and B1 with the cells you ought to be in contact interior the sum. This additionally is going for including , multiplying and dividing purely replace the minus sign with those * - Multiply + - Plus / - Divide wish this facilitates
2016-12-18 13:42:13 · answer #2 · answered by Anonymous · 0⤊ 0⤋
yep, just like that. Except you need to add the row number.
So, enter something like
=2*A1*B1+2*A1*B1+A1*B1
Keep in mind order of operation.
2007-06-04 07:34:46 · answer #3 · answered by Anonymous · 2⤊ 0⤋
it is very possible just use the tool function with 1 variable data tables...
2007-06-04 07:34:04 · answer #4 · answered by Whitney C 3 · 0⤊ 1⤋
=2*(2*(A2*B2))+(A2*C2)
Cell
A2 is the "X" cell
B2 is the "Y" cell
C2 is the "z" cell
D2 is where the formula goes
2007-06-04 07:39:54 · answer #5 · answered by No Name 4 · 0⤊ 1⤋
Go to:
2007-06-04 07:33:12 · answer #6 · answered by ELfaGeek 7 · 0⤊ 1⤋