Penny Arcade Forums› Help / Advice Forum
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

Excel Equations

AeroAero Registered User regular
edited February 2009 in Help / Advice Forum
I'm trying to compute a bunch of data in excel, and I have a column of data I want to normalize with 1 value. I have the normalization value stored in F128, and my column of data goes from L10 to L29. So I make a new column and give it the equation = L10 / F128, then drag this equation to the rest of the values, so that L increments. How do i make it so the reference to value F128 doesnt change per row? I know i can just copy verbatim the value from F128, but it will probably change, and I might not remeber to alter every column its referenced in.

Aero on

Posts

  • Options
    the wookthe wook Registered User regular
    edited February 2009
    =L10 / $F$128

    the wook on
  • Options
    AeroAero Registered User regular
    edited February 2009
    Thanks, worked like a charm.

    Aero on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum