The net profit in Excel income statement is set as: net profit = total profit-income tax expense; Set the total profit as: operating profit+non-operating income-non-operating expenditure; Operating profit is set as: operating income-operating costs-taxes-sales expenses-management expenses -R&D expenses-financial expenses-asset impairment loss-credit impairment loss+other income+investment income+fair value change income+asset disposal income. The essence of net profit is the operating results of an enterprise in a certain period of time.

1, we double-click the shortcut icon of excel on the desktop, and then open the software excel to enter its operation interface.

2. After opening excel, press Ctrl+O to find our table file in the pop-up dialog box, and then open it.

3. After opening the form file, select the cell in the commission and enter our calculation formula in it.

4. After entering the calculation formula, press Enter to get the calculation result, and then move the mouse to the lower right corner and drag, so that all commissions are calculated.

5. Select the cell of salary, and then enter the formula in it.

Income minus cost minus expenses minus tax equals profit.