0 |
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. |
1 | Guru
ID: 330592710 Tue, Dec 15, 2009, 14:52
|
Put a $ in front of each 1.
(B$1 - B2) / (D$1 - D2)
|
|
|
Post a reply to this message:
|