MS EXCEL (Math: Product / Addition)

Page 2 of 2 FirstFirst 12
  1. AndreTen's Avatar
    Posts : 23,382
    Windows 10 (Pro and Insider Pro)
       #11

    Fafhrd said:
    If you select cells E4 and F4, and then continue the selection down , for say 100 rows, with <Shift>+<down arrow> keys, then enter <Ctrl>+D to copy down, then the formulae in both E4 and F4 should be copied down in those 100 rows. You only seem to have copied down in the column E. You can check whether there are formulae in a cell by clicking it and checking what is in the cell edit box.
    Or just mark the last cell with good formula click and hold on cross mark (lower right corner of cell) and drag down... Formula will be copied in all cells

    MS EXCEL (Math: Product / Addition)-image.png

    result:

    MS EXCEL (Math: Product / Addition)-image.png

    Edit: and you don't need to have zero (0) in that empty row. There is the same formula in F column... (empty cell is zero)
    Last edited by AndreTen; 30 Sep 2017 at 04:59.
      My Computers

  2. DW7EZV's Avatar
    Posts : 48
    Microsoft Windows 10 Pro X64 19H2 v1909 Build 18363.778
    Thread Starter
       #12

    Thank you all!
      My Computers


 
Page 2 of 2 FirstFirst 12

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 05:21.
Find Us




Windows 10 Forums