Forum Discussion

Banzel99's avatar
Banzel99
Copper Contributor
Jun 27, 2023

Division formula

I'm a newbie to Excel formulas.  In column C my table shows the monthly billing totals for our shared neighborhood well.  I want Column D to show the value from column C divided by 6.  I have formatted column D to display the result to the third decimal place. How do I create a formula to have this happen without having to type it into each line of the spreadsheet?

Formulas and Functions

3 Replies

Sort By
    • Banzel99's avatar
      Banzel99
      Copper Contributor
      Jun 28, 2023

      Riny_van_Eekelen ok, but how do I get it to apply Cx/6, where x is each line in Column C, except the header, without having to create the function in each cell in column D?

      • leoperdia's avatar
        leoperdia
        Copper Contributor
        Jun 28, 2023

        Hi Banzel99 , you have couple of options: 

         

         

        -You can copy cell D2 in following rows. The formula will be created in reference to hte corresponding row. C3/6, C4/6 and so no

         

        -Also, If you already have completed column C, you can double click in right/botton corner and formula will be automatically copied until last row in column C.

         

         

        Let me know if it's works for you.

        Regards

        https://www.upwork.com/freelancers/~01cf0fc8446b00f44c 

         

         

         

Resources