Forum Discussion

mata2121's avatar
mata2121
Copper Contributor
Sep 26, 2019

Custom formula in Excel

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

excel
Excel on Mac
Formulas and Functions
office 365

2 Replies

  • jpigg's avatar
    jpigg
    Copper Contributor
    Sep 27, 2019
    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.
    • Subodh_Tiwari_sktneer's avatar
      Subodh_Tiwari_sktneer
      Silver Contributor
      Sep 27, 2019

      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.

Resources