marking up prices formula

I have found some threads on how to mark up prices using a percentage in excel, but I have not found out how I can put a percentage in one cell and have all the prices update. With the formulas I found, I have to go through every cell and input the formula to have it the prices updated. Any help would be very much appreciated. The formulas I have found are "=A1+(A1*B1)" and "=COST/(1-MARKUP)". These work but I have to type this in every cell to update the price. I am including my spreedsheet that I am working on to give you an idea of what I need.

You will need an extra column in your sheet to put the base price say col J

In another cell say K1 enter your markup %
Then in K where you want the marked up prices it is J4+(J4*K1) and just copy this formula down the column

Ed

I have the formula working but when I try to copy it down the table it gives me errors (########). Is there a special to copy the formula?

Hi,

It looks like your column needs to be wider.

Easiest way to copy down is to move curser to the bottom right corner of source cell and click and hold on the little '+' while dragging down through the destination area

Ed