This is super basic, so sorry for that:

If I insert this formula (f.ex.)

```
=CELL("address")
```

it shows the current cell address/position - f.ex. $E$5

However, if I insert the same forumula in the row below, the result in both cells change. So, it doesn't show the correct value if I use it more than once. How do I solve this super-basic excel "thing"?

If I f.ex. insert the formula in cells E5 and E6, both cells will show $E$6, instead of $E$5 and $E$6.

EDIT:

I got an answer below, saying that this formula should be used instead:

```
=ADDRESS(ROW(),COLUMN())
```

However, this just results in Excel complaining about the forumla having an error...?

EDIT 2:

Replace "," with ";", and it works.