Forum Discussion

Bill_9A's avatar
Bill_9A
Copper Contributor
Sep 20, 2023

Need assistance with Column formula

I need to Multiply Column D by Cell E1 with results showing in Column E

1 Reply

  • Bill_9A 

    Clear E2:E15.

    Select E2:I15 (or further to the right if required).

    Enter the formula =D2:D15*E1:I1 (adjust I1 as needed)

    If you have Microsoft 365 or Office 2021, press Enter.

    If you have an older version, press Ctrl+Shift+Enter.