Copy a formula instead of creating a new one
First, select cell B7.
Next, as the picture shows:
Then position the mouse pointer over the lower-right corner of the cell until the black cross (+) appears.
The Auto Fill Options button appears to give you some formatting options. In this case, you don’t need formatting options, so no action is required. The button disappears when you next make an entry in the cell.