Sep 23 2021 12:02 PM
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)
Sep 23 2021 12:36 PM
SolutionSep 23 2021 12:56 PM
thank you i knew it was something simple like that @Hans Vogelaar
Sep 23 2021 04:03 PM
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.
Sep 23 2021 12:36 PM
SolutionChange C34 to C$34
The $ makes the row reference absolute, i.e. non-changing.