Question: how do you create a formula in excel without using a function?
Answer: Select the cell A1. Copy the cell by pressing the key Ctrl+C on your keyboard. Select the cell B1, right click with the mouse. From the shortcut menu, select the Paste Special option. The Paste Special dialog box will appear. Click on Multiply in the Operation section.