Help needed with an excel formula

[RebeccaHodges]

I am working with a large spreadsheet and I am needed to populate the same formula for multiple lines.  I am trying to get the percentage of my income (C34) that each expense is with the below formula.  When I click and drag to copy the formula to all of the expenses I can't remember how to get it to hold on to the C34 with out increasing it a row for each row e.g., C35, C36 and so on.  Thank you for your help

=+IF(C34>1,ROUND((100*C115)/C34,2),0)

[#2 · Accepted solution]

@RebeccaHodges 

Change C34 to C$34

The $ makes the row reference absolute, i.e. non-changing.

[#3]

thank you i knew it was something simple like that @Hans Vogelaar 

[#4]

@RebeccaHodges 

If you had Excel 365, you could use a single dynamic array formula

= ExpenseItems/Income

and format as a percentage, where the defined names provide absolute references.  It will also work as a CSE array formula on legacy versions of Excel but that is less attractive as a solution.