MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula setup help

Posted by Anna Schwartz on February 03, 2002 1:06 AM

Hi everyone.

Here's what I want excel to do. I'm working on a grocery price list. In Column E I have the wholesale price. In Col. F, I want the total Markup (E x .4103) and then in G I want E + F. I understand each formula and how to make them. What I need to know is how to make it affect the WHOLE COLUMN so that, in each row, the formula is tailored to that row. For example:

row 5

COL E = 1.00
COL F = (E5, .4103)
COL G = SUM(E5, F5)

How can I make it so that each row has it's own, personalized formula without having to type it into each and every cell?

Please help me. I've been working on this for hours.



Posted by Aladin Akyurek on February 03, 2002 1:43 AM

Lets say that E2 houses your first wholesale price.

In a free cell, say, H1 enter: .4103

In F2 enter: =E2*$H$1

In G2 enter: =E2+F2

Select cells F2:G2 and double click the fill handle (the little square in the lower right corner of the cell) of G2 or drag G2 down with the fill handle.