Need Excel Help

i haev to make sheet with price in excel-t eproblem is taht i want to put formula in price.but when i copy formula from one cell to other the amount is also change to that i copied.I need formula with original price.
Or can any bdy tell me how to increase price with formula to the list without input aagain n again formula.
Plz reply ASAP.
Regards-Syma.

Dear Syma,
You may do one thing, you copy the sheet along with formula,
While pasting it to other sheet.. go to paste special function and click paste formula option.. hope your problem will be solved..
Regards,
Amit Seth.

you may prefix the cell address in which you constant price is with a $.
For e.g, if your constant price is in cell B5.. in the formula instead of B5 you put $B$5. Now wherever you take the formula, the constant price will be looked at only in that cell.
Guess this could help you.