 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006keeping one cell constant
if the formula is A1*A2 on the first row and for each other row i want B2, C2 etc to always be multiplied by A1 how can i do this. At the moment if i copy the formula from 1 row to the next it doesnt how the first as the constant. pls let me know the formula i need to use Try this: =$A$1*A2 And then look up the difference between relative and absolute cell references in the Help files.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > if the formula is A1*A2 on the first row > and for each other row i want B2, C2 etc to always be multiplied by A1 how > can i do this. At the moment if i copy the formula from 1 row to the next > it doesnt how the first as the constant. pls let me know the formula i > need to use
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.