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
Highlighted
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
Highlighted
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.
Highlighted

@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.