How To Use Excel Calculator

The excel launch page will open.

How to use excel calculator. If you want to calculate a percentage of a number in excel simply multiply the percentage value by the number that you want the percentage of. Click options on the bottom of the left hand sidebar. Now press on the enter key multiplication will be calculated. Choose the cell where you want the result for fv to go. For you to be able to use the correlation tool you need to load the excel analysis toolpak.

Step 1 select the cell you would like to display the calculation in by clicking it with your mouse. Use the datedif function when you want to calculate the difference between two dates. Excel formulas work like a basic calculator and follow the same kinds of rules you would use for a basic scientific calculator. How to use excel as a calculator. For example if you want to calculate 25 of 50 multiply 25 by 50.

Click file from the tab list. Type the following formula into any excel cell. Then type a formula like one of the following. To make your own financial calculator in excel start a new file or sheet and label fields for rate nper pmt pv and type and add some sample values. Now create headers for multiplication summation subtraction and square root in row one.

For simple formulas simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use the plus sign to add the minus sign to subtract the asterisk to multiply and the forward slash to divide. If you re not sure how to load the toolpak here s a summary of how to load the analysis toolpak. Write in cell c2 and use asterisk symbol to multiply a2 4. Click insert then function or f x on the task bar to open insert function window. First put a start date in a cell and an end date in another.

Think of this cell as the results line on your calculator. Another way to count days between dates in excel is by using the datedif function which is specially designed to work out the date difference in various units including days months and years. In the left column select financial. I f the start date is greater than the end date the result will be num. Use the equal sign to calculate.