Brain fart in simple subtraction

[Fritz W]

How do I fix a cell that is always subtracted from?

I want to have b2 a fixed value
then c3=b2-b3
d3=b2-d3
e3=b2-e3

If I just pull cell down to copy I get
d3=b3-b4
e3=b4-b5

Brain fart I am sure

 

[Gord Dibben]

=$B$2-B3

See help on absolute and relative references.

BTW your examples show you are copying across, not down

C3, D3 and E3 are in same row.


Gord Dibben MS Excel MVP

 

[Eduardo]

Hi,
use

c3=$b$2-b3