How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering
Category: Mac
Satisfied Customers: 9666
Experience:  Worked on Macs and PC's for 20+ years.
53785
Type Your Mac Question Here...
John D is online now
A new question is answered every 9 seconds

In excel, I have a formala that I want to repeat, but I want

This answer was rated:

In excel, I have a formala that I want to repeat, but I want one of the variables to stay the same, while the other increases down the column

Hi,

 

Could you post the formula in your reply and identify which cell reference needs to be fixed and which should increase

 

 

Customer: replied 5 years ago.
=O3*M111 I want the o3 to increase to o4, but the m111 to stay as m111

Ok, paste this formula in row 3 in an empty column (e.g. in cell S3)

 

=O3*$M$111

 

Then copy the formulas down to as many rows as you like

 

Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

John D and 2 other Mac Specialists are ready to help you