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
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
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
Popular recommendations
-
-
Hero Excel set wizard
Version: 1.007Size: 5MB
Hero Excel Template Wizard is a truly usable template printing software that can fill templates with Excel data and perform batch printing. Can be customized...
-
Quotation software
Version: 1.1 official versionSize: 139MB
Make a quotation, make a quotation form, open a cloud store, cloud quotation, and smart quotation.
Quotation software features
...
-
Enjoy sales XP version
Version: 1.6.2Size: 27.1MB
The official version of Fenxiangxiike XP version is a professional and powerful WinXP-specific mobile office service platform. Fenxiangxiike XP version supports lead management, customer management, business...
-
Enjoy sales
Version: 3.1.2Size: 53 MB
The official version of Fenxiangxike is a very good desktop client for Windows. The official version of Fenxiangxike is more powerful and practical than mobile phones. It can make work communication faster...