Excel formula question

[richa mishra]

Excel formula question

 

[Peter_SSs]

Welcome to the MrExcel board!

• Hard to read the image, Check out XL2BB
• What is your actual question?
• Looks like an assignment/test, so what have you already tried and what problems have you encountered? We are happy to help but don't feel obliged to actually do your assignments for you.

 

[richa mishra]

Welcome to the MrExcel board!

• Hard to read the image, Check out XL2BB
• What is your actual question?
• Looks like an assignment/test, so what have you already tried and what problems have you encountered? We are happy to help but don't feel obliged to actually do your assignments for you.

That's not my assignment.
That's net jrf question

 

[shift-del]

Switch between relative and absolute references - Microsoft Support

Change a cell reference from relative (default) to absolute to maintain the original cell reference when you copy it. Maintain cell reference by putting a dollar sign ($) before the cell and column references.

support.microsoft.com