Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-775820%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775820%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20adding%20columns%20D%20%26amp%3B%20E%20together%20in%20F.%26nbsp%3B%20I%20then%20want%20to%20multiply%20F%20by%202%20and%20add%20G%20for%20the%20total%20in%20H.%26nbsp%3B%20What%20is%20the%20formula%20to%20input%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-775820%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775843%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775843%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382924%22%20target%3D%22_blank%22%3E%40Susan455%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20mean%20under%20adding%20D%20%26amp%3B%20E%3F%20That's%20%3DD1%2BE1%2C%20or%20%3DD1%26amp%3BE1%20in%20F1%3F%20And%20what's%20the%20final%20result%2C%20that's%20%3D2*F1%2BG1%20in%20H1%2C%20or%20%3D2*SUM(F%3AF)%2BSUM(G%3AG)%20in%20H1%20or%20something%20else%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-775910%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-775910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F382924%22%20target%3D%22_blank%22%3E%40Susan455%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Susan%3C%2FP%3E%3CP%3EYou%20can%20type%20in%20H1%26nbsp%3B%3C%2FP%3E%3CP%3E%3DSUM(D1%3AE1)*2%2BG1%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Susan455
Occasional Visitor

I am adding columns D & E together in F.  I then want to multiply F by 2 and add G for the total in H.  What is the formula to input?

2 Replies

@Susan455 

What do you mean under adding D & E? That's =D1+E1, or =D1&E1 in F1? And what's the final result, that's =2*F1+G1 in H1, or =2*SUM(F:F)+SUM(G:G) in H1 or something else?

@Susan455 

Hi Susan

You can type in H1 

=SUM(D1:E1)*2+G1

Hope that helps

Nabil Mourad

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
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies