Home

Custom formula in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-878098%22%20slang%3D%22en-US%22%3ECustom%20formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878098%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EG2%20is%20the%20result%20from%20doing%20by%20hand%3A%20D2(times%203)%2BE2%2FD2(times%203)%20%2BE2%2BF2(times%203)%2BE2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20wondering%20if%20that%20formula%20can%20be%20applied%20to%20the%20rest%20of%20the%20G%20columns%2C%20with%20their%20respective%20numbers%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-878098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878183%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878183%22%20slang%3D%22en-US%22%3EHello%20Mata%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYes%2C%20if%20you%20copy%20the%20formula%20from%20G2%20and%20past%20it%20in%20the%20cell%20beneath%20it%2C%20the%20formula%20will%20automatically%20adjust%20for%20the%20new%20row.%20An%20even%20easier%20method%2C%20while%20you%20have%20G2%20as%20the%20selected%20cell%2C%20you%20can%20either%20drag%20the%20box%20from%20the%20bottom%20right%20corner%20of%20the%20cell%20to%20fill%20the%20cells%20beneath%20G2%2C%20or%20you%20can%20double%20click%20the%20bottom%20right%20corner%20of%20the%20box%20to%20auto-fill%20the%20remaining%20cells%20in%20the%20column.%20Hopefully%20that%20does%20what%20you%20were%20looking%20to%20do.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878218%22%20slang%3D%22en-US%22%3ERe%3A%20Custom%20formula%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F416063%22%20target%3D%22_blank%22%3E%40jpigg%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20you%20calculated%20by%20hand%20can%20be%20written%20as...%3C%2FP%3E%3CP%3EIn%20G2%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3D(D2*3%2BE2)%2F((D2*3%2BE2)%2B(F2*3%2BE2))%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EFormat%20G2%20as%20percentage%20with%20two%20decimal%20points%20and%20then%20copy%20it%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
mata2121
Occasional Visitor

Hi, 

G2 is the result from doing by hand: D2(times 3)+E2/D2(times 3) +E2+F2(times 3)+E2

 

I am wondering if that formula can be applied to the rest of the G columns, with their respective numbers?  

 

 Thank you

2 Replies
Hello Mata,

Yes, if you copy the formula from G2 and past it in the cell beneath it, the formula will automatically adjust for the new row. An even easier method, while you have G2 as the selected cell, you can either drag the box from the bottom right corner of the cell to fill the cells beneath G2, or you can double click the bottom right corner of the box to auto-fill the remaining cells in the column. Hopefully that does what you were looking to do.

@jpigg 

What you calculated by hand can be written as...

In G2

=(D2*3+E2)/((D2*3+E2)+(F2*3+E2))

Format G2 as percentage with two decimal points and then copy it down.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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