Excel 2010 - absolute cell reference in formulas

I have the following formula

=ROUND(C2*$J2,0)

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

=ROUND(C5*$J2,0)

but instead I get

=ROUND(C5*$J5,0)

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

Thank You
LVL 1
ank5Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Make it

$J$2
0
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.