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.
Thanks.
Anna