This is super basic, so sorry for that:
If I insert this formula (f.ex.)
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.
I got an answer below, saying that this formula should be used instead:
However, this just results in Excel complaining about the forumla having an error...?
Replace "," with ";", and it works.