Home

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-774225%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774225%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20general%20formula%20(%3DF6*G6)%20and%20then%20copied%20all%20they%20way%20down%20my%20column%20(1312%20lines)%3C%2FP%3E%3CP%3Eevery%20row%20no%20matter%20what%20the%20value%20is%20in%20F%20or%20G%20is%20showing%20the%20same%20total%20in%20each%20of%20the%20result%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EColumn%20F%3C%2FTD%3E%3CTD%3EColumn%20G%3C%2FTD%3E%3CTD%3EResults%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1260%3C%2FTD%3E%3CTD%3E0.245%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2137%3C%2FTD%3E%3CTD%3E0.00701%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3000%3C%2FTD%3E%3CTD%3E0.00701%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E9863%3C%2FTD%3E%3CTD%3E0.00701%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5000%3C%2FTD%3E%3CTD%3E0.085%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E4000%3C%2FTD%3E%3CTD%3E0.047%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E2500%3C%2FTD%3E%3CTD%3E0.01095%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E3000%3C%2FTD%3E%3CTD%3E0.2205%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E439%3C%2FTD%3E%3CTD%3E0.2205%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5000%3C%2FTD%3E%3CTD%3E0.0036%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E15000%3C%2FTD%3E%3CTD%3E0.0036%3C%2FTD%3E%3CTD%3E%24308.70%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMight%20something%20have%20been%20turned%20off%20in%20my%20setting%20that%20isn't%20auto%20updating%20the%20results%20for%20each%20of%20these%20cells%3F%20The%20only%20way%20I%20can%20get%20it%20to%20update%20right%20now%20is%20to%20F2%20each%20cell%20that%20I%20want%20it%20to%20update.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-774225%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%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-774287%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774287%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316362%22%20target%3D%22_blank%22%3E%40EWillis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECheck%20in%20Formulas%20section%20of%20the%20ribbon%20what%20you%20are%20not%20in%20manual%20calculation%20mode%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20354px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124541iF11A0FD81BA93E81%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
EWillis
New Contributor

I have created a general formula (=F6*G6) and then copied all they way down my column (1312 lines)

every row no matter what the value is in F or G is showing the same total in each of the result cells.

 

For example

Column FColumn GResults
12600.245$308.70
21370.00701$308.70
30000.00701$308.70
98630.00701$308.70
50000.085$308.70
40000.047$308.70
25000.01095$308.70
30000.2205$308.70
4390.2205$308.70
50000.0036$308.70
150000.0036$308.70

 

Might something have been turned off in my setting that isn't auto updating the results for each of these cells? The only way I can get it to update right now is to F2 each cell that I want it to update.

1 Reply

@EWillis 

Check in Formulas section of the ribbon what you are not in manual calculation mode

image.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies