Excel 2010 - absolute cell reference in formulas

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
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Make it

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.