How to quickly calculate sales wages and commissions based on commission ratio in Excel

How to quickly calculate sales wages and commissions in Excel, does it trouble you? PHP editor Apple provides a detailed guide on how to easily set the commission ratio formula, step by step, so that you can complete salary calculation efficiently. Read on to learn the tips for calculating commission in Excel and improve your work efficiency!

Open Excel and enter its operation interface.

After opening Excel, press the Ctrl O key, find our table file in the pop-up dialog box, and then Open it,

After opening the table file, select the cell in the commission and enter our calculation formula in it,

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

After selecting salary cell, and then enter the formula in it,

After entering the formula and pressing the Enter key, you will get the salary.

After getting the salary, move the left mouse button to the lower right corner, and then drag to calculate all the calculation results.

The above is the detailed content of How to quickly calculate sales wages and commissions based on commission ratio in Excel. For more information, please follow other related articles on the PHP Chinese website!