Difficulty: Moderately challenging
Things You’ll Need:
Step1
Start Microsoft Excel and open the file you want to change.
Step2
Click on the cell in which you want the total to appear.
Step3
Open the Insert menu and choose Function. The Paste Function dialog box appears.
Step4
Select the function category from the list in the Paste Function dialog box - for example, Financial.
Step5
Select a function from the Function Name list in the Paste Function dialog box. (For example, in the Financial category, NPV calculates the Net Present Value of an investment.) A brief description of the function appears at the bottom of the dialog box. The function's arguments (the values it needs to calculate the result) are listed as well.
Step7
In the box that appears, enter the cell names (for example, E2, B4, C2) you want to use for the formula you chose. The number of cells you need depends on the formula.
Step8
Click OK to accept the formula.