Forum Discussion

priscillamaria's avatar
priscillamaria
Copper Contributor
Oct 23, 2019

Help with Excel

Can someone help me with filling up my document. I know the formula I need to use which is =(some # * some #)/1000. I don't know how to fill up the other cells. I've been entering the formula one-by-one and there's like 63 cells and it's taking me a long time. I was told that if i just select the data and hit enter it should do the math with the formula but when I try nothing happens. I added a screenshot of my document. I am supposed to calculate the numbers from the tidal volume and times it with the breaths/ min and divide by 1000.

 

Excel Excel on HP laptop

7 Replies

  • crieb's avatar
    crieb
    Copper Contributor
    Oct 23, 2019

    Are you trying to enter the formulas in columns X - AA?  In X3, type =(P3*T3)/1000 then hit Enter.  You can then copy (Ctrl + C) and paste (Ctrl + V) down to all your rows and across to all your columns.  priscillamaria 

    • priscillamaria's avatar
      priscillamaria
      Copper Contributor
      Oct 26, 2019

      Hi thank you for the help but it didn't work. I don't know what I'm doing wrong. It either gives me the same number as the one I already calculated or it does nothing.crieb 

      • PeterBartholomew1's avatar
        PeterBartholomew1
        Silver Contributor
        Oct 26, 2019

        priscillamaria 

        Why don't you post a sample of your workbook, I am sure one of the others will enter the formulas for you to start you off.

         

        My approach is different and only relevant to Office 365 users with dynamic arrays.  I don't enter data except without first naming the data input ranges.  The formula I write into cell X3 is then

        = TidalVolume * Breaths / 1000

        Press Enter, and the array spills to provide a complete dataset.  There are also more traditional approaches closer related to the other solutions to your problem.

    • nabilmourad's avatar
      nabilmourad
      MVP
      Oct 23, 2019

      crieb 

      Hi

      You can select the whole range upfront (the 63 Cells)

      The cell from which you started the selection is different in color (called Active Cell)

      Type an equal sign >> Create the Formula in the Active Cell >> Followed by hitting CTRL + Enter (Not Enter) >> The formula is created in the entire range.

      Hope that helps

      Nabil Mourad

Resources