View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Brain fart in simple subtraction

Hi,
use

c3=$b$2-b3

"Fritz W" wrote:

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 :)


.