Home

Excel Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-500643%22%20slang%3D%22en-US%22%3EExcel%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500643%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20link%20two%20cells%20together%20with%20a%20%3D%20cell1%20minus%20cell2%20but%20I%20need%20to%20be%20able%20to%20put%20a%20value%20in%20cell%202%20the%20the%20formula%20will%20use%20I%20know%20that%20I%20could%20use%20%3D%205%20-D1%20and%20get%20a%20result%20but%20what%20I%20need%20is%20to%20be%20able%20to%20change%20the%205%20with%20out%20making%20a%20new%20formula.%20%26nbsp%3BThank%20You%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500643%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-501066%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-501066%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329944%22%20target%3D%22_blank%22%3E%40Tomlundy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20cannot%20have%20a%20formula%20in%20a%20cell%20and%20combine%20it%20with%20a%20manual%20entry%20in%20that%20same%20cell.%20That%20is%20not%20how%20Excel%20works.%20Enter%20data%20into%20cells.%20Then%20use%20formulas%20in%20other%20cells%20to%20calculate.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20A1%20has%20the%20value%205%2C%20then%20you%20can%20calculate%20%3DA1-D1%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20you%20can%20change%20the%20value%20in%20A1%20to%20a%20different%20number%2C%20the%20result%20of%20the%20formula%20will%20update%20immediately.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20need%20help%20with%20this%20concept%2C%20please%20post%20a%20few%20more%20details%20about%20what%20you%20are%20trying%20to%20achieve.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Tomlundy
Occasional Visitor

I am trying to link two cells together with a = cell1 minus cell2 but I need to be able to put a value in cell 2 the the formula will use I know that I could use = 5 -D1 and get a result but what I need is to be able to change the 5 with out making a new formula.  Thank You for the help.

1 Reply

Hello @Tomlundy 

 

You cannot have a formula in a cell and combine it with a manual entry in that same cell. That is not how Excel works. Enter data into cells. Then use formulas in other cells to calculate.

 

If A1 has the value 5, then you can calculate =A1-D1 

When you can change the value in A1 to a different number, the result of the formula will update immediately.

 

If you need help with this concept, please post a few more details about what you are trying to achieve.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies