Get instant live expert help on I need help with excel cell reference function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Using the address function to reference a cell. I want to return the contents of that cell on a different sheet.
Solved by T. B. in 19 mins
In cell B7, enter a formula using the function for the Double-declining balance depreciation method. Use the cell names Cost and Salvage for the Cost and Salvage function arguments. Use the appropriate cell reference for the Life argument. Use the appropriate cell reference for the Period argument. Be sure to use the appropriate cell reference types to allow you to copy the formula to the rest of the column. Use a multiplier of 3.
Solved by G. U. in 26 mins
In cell B6, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9.
Solved by T. J. in 25 mins
I am using formulas-create from selection to name cells and would like the cells "name" to appear when referencing the cell rather than the =worksheet(cell) reference similar to excel 2013 "labels" function.
Solved by K. H. in 17 mins
In cell J3, use the IF function to calculate the retirement matching for each faculty member who is participating in the retirement plan. For participating members, the function should multiply their salary by the retirement matching percentage. For all other members, the function should return 0. Be sure to make the reference to cell J1 an absolute reference in the function. Use the fill handle to copy the function down through the column. Apply the currency format to the values.
Solved by I. H. in 13 mins