First spreadsheet... forumla help

[_Brad]

OK so I've got a big chart of lots of numbers and I need to apply some
formulas to them so I can get what I need from them. Here's a sample
of some of them. What I need from this particular list is 6(A) +
(B/10) - 2(C) + (D/10) + 6(E).


A B C D E

17 1335 0 441 1
14 892 2 187 1
16 1696 0 170 4
13 1128 2 169 0
9 1548 0 483 0
13 1518 2 578 2
9 1074 4 228 0
3 812 0 703 6
12 1635 0 103 1
7 819 3 109 0
13 1188 4 588 1
5 1315 4 235 2
5 1133 1 180 1
7 1006 0 116 0
12 1454 4 84 0
7 1163 0 275 1
2 479 0 112 0
4 673 0 189 0
12 1697 0 245 2
9 1106 1 294 0
8 1154 0 184 0
7 1054 0 189 1
2 255 0 76 0
3 396 0 80 0
7 948 1 427 0
7 822 2 212 0
6 1067 4 147 0
7 950 0 145 0
2 1224 2 345 1
1 276 0 107 1
1 830 0 55 0
13 941 0 46 0
3 774 0 310 1
9 581 0 278 2
2 744 3 178 1
8 509 0 15 0
6 1240 0 241 2

If you could write a formula that would do all this automatically for
me then explain how you did it so I can do the rest of it myself, that
would be really great. Thanks for your help.

 

[Smejk]

Not sure if this is what you want or not, may need you to further
explain your problem, but here goes.

In column F put the following in the same row as your first figures:
=(6*A1)+(B1/10)-(2*C1)+(D1/10)+(6*E1)

That will display your figure for that row...I guess you can take it
from there.

 

[Paul Sheppard]

OK so I've got a big chart of lots of numbers and I need to apply som
formulas to them so I can get what I need from them. Here's a sampl
of some of them. What I need from this particular list is 6(A)
(B/10) - 2(C) + (D/10) + 6(E).


A B C D E

17 1335 0 441 1
14 892 2 187 1
16 1696 0 170 4
13 1128 2 169 0
9 1548 0 483 0
13 1518 2 578 2
9 1074 4 228 0
3 812 0 703 6
12 1635 0 103 1
7 819 3 109 0
13 1188 4 588 1
5 1315 4 235 2
5 1133 1 180 1
7 1006 0 116 0
12 1454 4 84 0
7 1163 0 275 1
2 479 0 112 0
4 673 0 189 0
12 1697 0 245 2
9 1106 1 294 0
8 1154 0 184 0
7 1054 0 189 1
2 255 0 76 0
3 396 0 80 0
7 948 1 427 0
7 822 2 212 0
6 1067 4 147 0
7 950 0 145 0
2 1224 2 345 1
1 276 0 107 1
1 830 0 55 0
13 941 0 46 0
3 774 0 310 1
9 581 0 278 2
2 744 3 178 1
8 509 0 15 0
6 1240 0 241 2

If you could write a formula that would do all this automatically fo
me then explain how you did it so I can do the rest of it myself, tha
would be really great. Thanks for your help.

Hi Brad

Try this formula in column F

=SUM((A1*6)+(B1/10)-(C1*2)+(D1/10)+(E1*6))

Assuming your first row of numbers is in row1, if not change th
A1,B1....etc to matc the first row of your data

For the first set of numbers above, 17 1335 0 441 1 this returns
value of 285.6

If this is what you want you can then copy the formula down the column
either by click and drag - click in cell F1 if that is where your firs
formula is, the bottom right corner of the cell is a black square pu
the cursor over this it changes to a black cross, hold down the lef
mouse button and drag the formula down to the last row of data, or whe
the cursor is a black cross double click the left mouse button, thi
will copy the formula down to the last row of dat

 

[_Brad]

Yeah guys those are what I was looking for. Thanks for your help, I
think I'll be able to figure it out from here, but if not, I'll be
back. Thanks again.

 

[Earl Kiosterud]

Brad,

Presumably you want 6(A) + (B/10) - 2(C) + (D/10) + 6(E) for each row. Put
this in F1, and copy down with the Fill Handle (little black box in lower
right corner of cell):

= A1*6 + B1/10 - C1*2 + D1/10 + E1*6