Say I have the following sheet:

```
| A | B | C |
1 | 5 | 1 | 5 |
2 | 8 | 8 | 99 |
3 | 77 | 3 | 3 |
4 | 2 | 7 | 4 |
5 | | | |
6 | Base:| 2 | |
```

Now I want to apply such a 'formula' to the cells mentioned about : `=LOG(<cell>, B6)`

, where `<cell>`

is obviously the cell value of the above cells. Obviously, the `B6`

should remain as it is.

How can I do this without the copy and pasting?

**Update**: The problem with putting the formula in the first cell and dragging down is that the `B6`

gets incremented to `B7`

, `B8`

etc, but I want it to stay as `B6`