Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-26-2012, 07:15 AM
jprt68 jprt68 is offline Keep cell in formula constant Windows Vista Keep cell in formula constant Office 2010 32bit
Novice
Keep cell in formula constant
 
Join Date: Jun 2012
Posts: 1
jprt68 is on a distinguished road
Default Keep cell in formula constant

Say I have 2 columns a and b, as well as an Add column for example:

a b add
---------------
4 2
3 4
1 2


For the Add formula I would type =A2+B2 into the first cell, then just drag this down so that all other rows have appropriate formulas =A3+B3, =A4+B4 ... etc.

What if I had a forth column, e.g. "Multiply by Price" where Price is stored in another cell, e.g. F3.


a b add Multiply by Price
------------------------------------
4 2 6
3 4 7


1 2 3


Price
--------
7.5


So in the first "Multiply by Price" cell I would type =F3*A3
I want to be able to drag this down so that the formulas change to =F3*A4, =F3*A5 .... etc where the F3 remains constant.

What do I do to the formula to do this?
Reply With Quote
 

Tags
cell, formula, formulas



Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep cell in formula constant Use formula to copy cell formats also mike_abc Excel 10 12-10-2011 01:55 AM
Keep cell in formula constant need to check whether cell contains formula etodem Excel 2 10-23-2010 07:33 PM
Keep cell in formula constant Formula in a Cell with condition? Learner7 Excel 1 07-19-2010 10:10 AM
Keep cell in formula constant How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM
Keep cell in formula constant Protect formula in cell? markg2 Excel 4 05-24-2010 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft