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