Skip to main content

How to Calculate Commission in Excel?

How to Calculate Commission in Excel?, calculate commissions, commissions, commissions payment, if statement, microsoft excel, excel, functions, 

if we learn how to bring out commission in excel then we can make any sheet for office. This will be very helpful for marketing management people. Team leaders, MIS operators etc.

easy way to calculate commissions of sales person in excel,
How to Calculate Commission in Excel?


To do this we will use a table which will contain 5 headings in columns i.e. 

  • Name
  • Basic Salary
  • Sales Amount
  • Commission
  • Total Pay


Now we will use 

Nested IF to calculate COMMISSION

Commission Calculation Criteria are as Follows:

  1. Sales Amount is Less than 150000 then 10%
  2. Sales Amount is Greater than or Equal to  150000  and less than 350000 then 15%
  3. Sales Amount is Greater than 350000 then 20%

Now As per the Template we will use the following formula to calculate commission:

=IF(D6<150000,D6*10%, IF(D6>=150000,D6*15%,IF(D6>35000,D6*20%)))


And all Done.

Drag the formula down and we will get the result in every cell.

How to calculate TOTAL PAY:

Its very simple, for this we have to add the Basic salary and Commission, so the formula will be 

=c6+E6

Now Drag it down and we will get the results. 

So in this example of Commission calculation we have learned that how to do Nesting of IF condition. 

Download Template

एक्सेल में कमीशन की गणना कैसे करें?

ऐसा करने के लिए हम एक तालिका का उपयोग करेंगे जिसमें  5 शीर्षक होंगे अर्थात

  • नाम
  • मूल वेतन
  • बिक्री राशि
  • कमीशन 
  • कुल वेतन

अब हम प्रयोग करेंगे

कमीशन की गणना करने के लिए नेस्टेड IF

कमीशन गणना मानदंड इस प्रकार हैं:

  • बिक्री राशि 150000 से कम है तो 10%
  • बिक्री राशि 150000 से अधिक या उसके बराबर है और 350000 से कम है तो 15%
  • बिक्री राशि 350000 से अधिक है तो 20%

अब टेम्पलेट के अनुसार हम कमीशन की गणना करने के लिए निम्नलिखित सूत्र का उपयोग करेंगे:

=IF(D6<150000,D6*10%, IF(D6>=150000,D6*15%,IF(D6>35000,D6*20%)))

और सब हो गया।

सूत्र को नीचे खींचें और हमें हर सेल में परिणाम मिलेगा।

कुल वेतन की गणना कैसे करें:

यह बहुत आसान है, इसके लिए हमें बेसिक सैलरी और कमीशन को जोड़ना होगा, तो यह फॉर्मूला होगा

=c6+E6

अब इसे नीचे खींचें और हम परिणाम प्राप्त करेंगे।

तो कमीशन कैलकुलेशन के इस उदाहरण में हमने सीखा कि IF कंडीशन की Nesting कैसे करें।

अब आप कमीशन से सम्बन्धी कोई भी sheet बना सकते हैं |

How to Calculate Commission in Excel?, calculate commissions, commissions, commissions payment, if statement, microsoft excel, excel, functions.

Labels:

Comments

Post a Comment

Popular posts from this blog

Page Maker Tutorial

Adobe PageMaker 7.0 learn page maker Chapter 1 - Basic Information - PageMaker  Basic Information: Adobe PageMaker is powerful and versatile page layout software. Professionals use PageMaker for its exceptional typographic controls, exacting page design capabilities, including layers, frames, and multiple master pages, and numerous customizing options.  PageMaker’s extensive importing and linking capabilities let you incorporate text, graphics, spreadsheets, charts, and movie frames from most popular programs. It also incorporates menu plug-ins that extend the program’s features and capabilities. It also supports advanced color printing technologies, including high-fidelity inks, color management support, automatic trapping, built-in imposition tools, and complete separation capabilities for text and graphics. Let us first understand the PageMaker Window with its various components. Fig 1 shows the important areas of the PageMaker window: To check figures do
Read more

Career In Information Technology

Millions of vacancy comes out every year in Information technology sector. It is the fastest growing industry where scope will never end because of digitisation. A computer literate person is not only able to get job in nation but there is a great scope in international level. So there is a good chance of making career in this field. best career options in IT And if any one is entrepreneur then no doubt he or she can earn unlimited as per the calibre. Any student who have done course from Akhil Bhartiya Computer Shiksha Abhiyan Can Make Career In following ways: Student can open his or her own computer education center/computer training center of hardware and software. Student can become web designer. Student can become a network engineer. He or she can become faculty/teacher in any institute. Person can get job as a computer operator. Student can start career as a hardware professional. Person can become a programmer or software developer. Student can work as
Read more

Welcome To ABCSA

Franchise of Computer Centre, Akhil Bhartiya Computer Shiksha Abhiyan, Start computer center? Welcome to Akhil Bhartiya Computer Shiksha Abhiyan Akhil Bhartiya Computer Siksha Abhiyan (ABCSA) is running under High-Tech Information Technology Development as a Society/Trust Registered Under The Societies Registration Act, 1882 Under Section 60 Vide Registration No. 1483/IV From Govt. Of India, NCT Delhi And Also Registered Under The Society Act 1973, Under Section 44 Registration No. 07/33/04/13330/16 From Govt Of M.P. A LIFE LONG LEARNING COMMUNITY WITHOUT BORDERS . We use flexible approaches to make I.T. education accessible to all – anytime, anywhere. Our Learning environment is specially designed for the convenience and accessibility of adult learners of any age, gender, ethnicity and background. ABCSA The dream of Honorable Former President of India Dr. A.P.J. Abdul Kalam is to transform India into a developed nation, and this is possible only when in this elec
Read more