Excel 2010 - absolute cell reference in formulas

Posted on 2012-09-08
Last Modified: 2012-09-08
I have the following formula


When the formula is copied to another cell, I want J2 to continue to be referred. For Eg., when I copy the formula to cell 5, I expect the formula to change to


but instead I get


Can someone please help me identify the problem and a possible resolution.

Thank You
Question by:ank5
    1 Comment
    LVL 43

    Accepted Solution

    Make it


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    This article will show you how to use shortcut menus in the Access run-time environment.
    In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now