Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need one formula for large sections of one column, but....
small example of spreadsheet I'm creating. Need large sections of one column
to use the same formula but for all cells with diff context Column A B C D descr. mtl cost/per unit total cost for material Rows 1 2 158 $.17 formula =(b2*c2) 3 339 $.24 =(b3*c3) 4 355.95 $.50.88 =(b4*c4) 5 6 So my questions is can I fill Column D with one formula, or because the cell # changes do I have to enter it into each cell that I need the formula in? |
#2
|
|||
|
|||
In cell D2, you can enter
=b2*c2 You can then copy that cell down as far as needed. It will adjust the formula as necessary. "construction_secretary" wrote: small example of spreadsheet I'm creating. Need large sections of one column to use the same formula but for all cells with diff context Column A B C D descr. mtl cost/per unit total cost for material Rows 1 2 158 $.17 formula =(b2*c2) 3 339 $.24 =(b3*c3) 4 355.95 $.50.88 =(b4*c4) 5 6 So my questions is can I fill Column D with one formula, or because the cell # changes do I have to enter it into each cell that I need the formula in? |
#3
|
|||
|
|||
Thanks!
"Barb R." wrote: In cell D2, you can enter =b2*c2 You can then copy that cell down as far as needed. It will adjust the formula as necessary. "construction_secretary" wrote: small example of spreadsheet I'm creating. Need large sections of one column to use the same formula but for all cells with diff context Column A B C D descr. mtl cost/per unit total cost for material Rows 1 2 158 $.17 formula =(b2*c2) 3 339 $.24 =(b3*c3) 4 355.95 $.50.88 =(b4*c4) 5 6 So my questions is can I fill Column D with one formula, or because the cell # changes do I have to enter it into each cell that I need the formula in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formula for percent off of column | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
10,000 addresses in column A; divided into 4 sections across. | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |