How to quickly calculate stock returns using Excel 2010 formulas

Time: 2022-04-27Source: Huajun InformationAuthor:

1. Prepare your data as shown in the picture, enter your stock number and cost price, and you can calculate the cost. First enter the "=" sign, select the previous number, enter "*", then select the next number, and press the "Enter key". Your first formula is completed.

Excel2010

Excel2010

2. Learn a commonly used auto-fill function. Enter two numbers, select them, there is a small "+" in the lower right corner, click on it and pull down to see

Excel2010

Excel2010

3. To calculate the amount, you will use the "F4" key, which has the function of fixing your selections. "$F$7" will appear in your selection formula. This is the absolute selection.

Excel2010

Excel2010

Related articles更多>>

Popular recommendations