RotoGuru Computer Forum

View the Forum Registry

XML Get RSS Feed for this thread


Self-edit this thread


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.
1Guru
      ID: 330592710
      Tue, Dec 15, 2009, 14:52
Put a $ in front of each 1.

(B$1 - B2) / (D$1 - D2)
RotoGuru Computer Forum

XML Get RSS Feed for this thread




Post a reply to this message:

Name:
Email:
Message:
Click here to create and insert a link
Click here to insert a block of hidden (spoiler) text
Ignore line feeds? no (typical)   yes (for HTML table input)


Viewing statistics for this thread
Period# Views# Users
Last hour11
Last 24 hours11
Last 7 days33
Last 30 days1212
Since Mar 1, 200731881116