Need assistance with Column formula

Copper Contributor

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

Excel Question.jpg

1 Reply


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.