Home |
Search |
Today's Posts |
#2
|
|||
|
|||
Hi Gary
you need to put the formula in the first cell in column D e.g. =B1*C1 and fill down (if there's values in C the easiest way to do this is to move your cursor over the bottom right hand corner of D1 until you see a + and then double click). Cheers JulieD "Gary" wrote in message ... Not sure how to enter formulas against columns not cells. For instance on each row entered want columnD cells to always be the product of columnB cells and columnC cells. Any guidence is much appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |