• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

ctrl D--only copy the value, not reference

  • Thread starter Thread starter kc
  • Start date Start date
K

kc

New Member
A1=C1*1.1/K1, use ctrl D from A1 down to A3, in the cell, A2=C2*1.1/K2, A3=C3*1.1/K3, I want A2=C2*1.1/K1, A3=C3*1.1/K1, only the value in K1,not reference. how?
 
Hi ,


If my understanding is correct , what you need to do , is use :


=C1*1.1/$K$1


in A1 , and then use CTRL D for the range of interest.


Narayan
 
Welcome to Chandoo.org forums.


If you are interested in knowing why Narayan's approach works, read following article.

http://www.cpearson.com/excel/relative.aspx
 
You must log in or register to reply here.
Back
Top