Welcome to KnowledgeVarsity Forum! This Forum is to answer your queries regarding question text and its instructions for this specific question. Please take a minute before posting a question and see if you can find an answer to your question. If not, please post your question. The Forum moderator will respond very soon!
Hi I am having a hard time adjusting cell row and column references. I have successfully gotten the first piece answer correct for table 1,2 and 3, however since I do not know how to adjust the cell row and column references I get the wrong answers for the rest of the chart.
You can fix the column reference by inserting $ before the column name.
You can fix the row reference by inserting $ before the row number.
Alternately, you can press F4 multiple times to toggle the various references.
Kindly provide the formula and the cell range, so that we can assist you better,