syma
9

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.

From Pakistan, Karachi
Amitmhrm
496

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.

From India, Ahmadabad
jayb37
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.


Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.