# Excel salary sheet and its formula calculation

Video duration: 21:2
How to create excel salary sheet or excel salary statement with formula.this sheet is in a very simple format,it includes “IF” formula for all the allowances, the basic pay is based on loom some while the all the allowances are based on the standard “IF” formula including income tax, gross pay is the “SUM” of Basic pay Plus all allowances while the NET PAY is the subtraction of “Income Tax From Gross Pay

## 21 thoughts on “Excel salary sheet and its formula calculation”

#### Dania Gohar

(November 8, 2018 - 4:30 am)

chussss

#### Learn English

(November 8, 2018 - 4:30 am)

super

#### Aparna Pathak

(November 8, 2018 - 4:30 am)

Sir basic pay more or less which is good in terms of employee ?

#### Habiba siddiqui

(November 8, 2018 - 4:30 am)

Sir if functions starting se dikhao plzz mujhe bht problem ho rhi h and (and / or function wala bhi plzzzzz sir

#### AmazingLife

(November 8, 2018 - 4:30 am)

Learn MS Excel Full Formulas & Functions with mobile App :http://bit.ly/2ITwiIr
500 MS Excel Quiz Full Formulas & Functions is a full and free app course for MS excel 2016. This application is suitable both for beginners, advanced, as well as for schools and businesses . This app will guide you through the new features of MS excel2016 to help you easily learn Ms excel & excel function and Practice any time.

#### Jr Printing

(November 8, 2018 - 4:30 am)

how to stop points

#### Crazy Hunt

(November 8, 2018 - 4:30 am)

Very GOod Video sir Keep it Up

#### Pariwartan Computers MKCL

(November 8, 2018 - 4:30 am)

my mail id 16210022@mkcl.org

(November 8, 2018 - 4:30 am)

Sir agar over time dikhana Ho to

#### Vinod Gupta

(November 8, 2018 - 4:30 am)

wastage of time

#### Debashis panda

(November 8, 2018 - 4:30 am)

fabulous video when we will see this video then we will find out our solution.

#### Rayle Feigan

(November 8, 2018 - 4:30 am)

Fantastic video mate!!! Thank you very much 🙂

#### Birjesh Chaturvedi

(November 8, 2018 - 4:30 am)

good sir, very helpful, never found earlier any where. Thanks

#### RAKESH KUMAR PAL

(November 8, 2018 - 4:30 am)

nice

#### Sujit Banik

(November 8, 2018 - 4:30 am)

Excellent and what I searched to learn , I got it. With Profound respect. [ Uses & Implementation of If Formula].

#### Rajesh Kumar Pal

(November 8, 2018 - 4:30 am)

nice sir I want to know can employer dedicated esic

amount in my overtime

#### mariyam mariyam

(November 8, 2018 - 4:30 am)

how long formulas?

#### Prasanna Lakshmi

(November 8, 2018 - 4:30 am)

very nice sir

#### Uttam Roy

(November 8, 2018 - 4:30 am)