Previous Topic Next Topic

Salary calculator in Excel

Closed
Devashish - Updated on Apr 22, 2018 at 12:09 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 23, 2018 at 12:07 PM
I want to make a salary calculator( in excel ) in which I want to add 3% increment in "basic". My columns are :---- 1. "Month"=march 2017, April 2017 etc 2. "Basic"=50000 , 3. "D.A." = basic*.07, 4. "H.R.A."= basic*.08, 5. "Gross"= basic+da+hra .
Please help me .
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 23, 2018 at 12:07 PM
Hi Devashish,

Like this?:
B2: 50000
B3: =B2 * 1.03
Drag formula down so that:
B4: =B3 * 1.03
etc..

Or like this?:
B2: 50000
B3: =B2 + B$2 * 1.03
Drag formula down so that:
B4: =B3 + B$2 * 1.03
etc..


Is that what you meant?

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
2nd imei number
dinesh -
ash_perez01 -

1 response
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses