Salary calculator in Excel

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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 .

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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