Home

Question about copying a formula in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-879866%22%20slang%3D%22en-US%22%3EQuestion%20about%20copying%20a%20formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879866%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20copy%20a%20simple%20formula%20in%20excel%20but%20need%20the%20formula%20to%20change%20as%20I%20copy%20(and%20paste)%20it.%20The%20formula%20is%20(AG22%2F255)*T60.%20I%20know%20Excel%20will%20%22follow%22%20the%20sequences%20if%20I%20highlight%20a%20series%20of%20numbers%20in%20a%20cell%20and%20then%20drag%20into%20a%20corresponding%20series%20of%20cells%20(using%20the%20%2B%20sign%20in%20the%20lower%20right%20hand%20corner).%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20attempt%20to%20do%20the%20same%20thing%20with%20the%20formula%2C%20both%20of%20my%20variables%20change%20in%20the%20formula%20(and%20I%20only%20need%201%20to%20change).%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20in%20the%20formula%20listed%20above%2C%20I%20need%20the%20sequence%20to%20repeat%20as%20(AG22%2F255)*T60%2C%20(AG23%2F255)*T60%2C%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%20on%20how%20to%20only%20change%201%20variable%20and%20not%20both%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879866%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879879%22%20slang%3D%22en-US%22%3ERe%3A%20Question%20about%20copying%20a%20formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416539%22%20target%3D%22_blank%22%3E%40DZaleski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20that%2C%20make%20the%20T60%20as%20an%20absolute%20reference%20so%20that%20it%20doesn't%20change%20when%20you%20copy%20it%20down%20or%20across.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D(AG22%2F255)*%3CSTRONG%3E%24T%2460%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
DZaleski
Occasional Visitor

I am trying to copy a simple formula in excel but need the formula to change as I copy (and paste) it. The formula is (AG22/255)*T60. I know Excel will "follow" the sequences if I highlight a series of numbers in a cell and then drag into a corresponding series of cells (using the + sign in the lower right hand corner). 

But when I attempt to do the same thing with the formula, both of my variables change in the formula (and I only need 1 to change). 

So in the formula listed above, I need the sequence to repeat as (AG22/255)*T60, (AG23/255)*T60, etc. 

 

Any ideas on how to only change 1 variable and not both?

1 Reply

@DZaleski 

To do that, make the T60 as an absolute reference so that it doesn't change when you copy it down or across.

 

=(AG22/255)*$T$60

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies