Been having some problems with excel getting it to behave like Iwanted, tried google around but so clueless as to what to call things that it makes it hard. What I want is for a cell formula to do as I want when I pull on the lower-right corner down. Normally it the adds 1 to every cell address, but I need some of them to remain the same while others change. More exact:
I'm trying to make excelsheet where one collum is supposed to have the formula:
=F3*Dx/D3
x goes from 3 to eternity, while F3 and D3 should remain static while doing that drag thing. I remember there was a way to mark F3 and D3 so they don't change, but can't remember how.
So F4 has F3*D4/D3, F5 has F3*D5/D3 and so fourth.