Once you have entered a formula, you can copy and paste to the new cells for other calculations.
Step 1. Click the cell and enter a formula, press "Enter" to get the results;
Step 2. Right-click and copy the cell with formula;
Step 3. Select next data cell or a data range, and paste formula only;
Step 4: You will see the results in the new cells.