Forum: comp
Page 435
Subject: Excel Help


  Posted by: damoose7474 - [69322111] Tue, Dec 15, 2009, 14:47

For anyone who is pretty good in excel, I need a little bit of help.

I have the formula =(B1 - B2) / (D1 - D2)

The information goes from b1 to b218. If I want to fill right, how do I get the formula to switch to =(B1 - B3) / (D1 - D3)then to =(B1 - B4)/(D1 - D4)

I believe the $ sign is involved.
 
1Guru
      ID: 330592710
      Tue, Dec 15, 2009, 14:52
Put a $ in front of each 1.

(B$1 - B2) / (D$1 - D2)