Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by amrita » Mon Jun 13, 2016 12:50 am
Hi,
I have an excel sheet with employees name and total no of days they have been late in a month.
The deduction rules are 1 day for every 4 days late arrival and then half a day for subsequent late.
eg: if a person is late for 10 days then 4 days salary has to be deducted (1 day for first 4 days and .5 day for rest 6 days)
What formula can I use in my excel to automatically calculate this??
Thanks
-
amrita
- Rookie
-
- Posts: 2
- Joined: Jun 13, 2016
- Reputation: 0
- Excel Version: 2013
by ConneXionLost » Mon Jun 13, 2016 2:07 pm
How about:
- Code: Select all
=(A1>=4)+MAX(0,A1-4)/2
Where A1 is the number of late days.
Cheers,
-
ConneXionLost
- Regular
-
- Posts: 68
- Joined: May 9, 2013
- Location: Canada
- Reputation: 19
- Excel Version: 2003, 2010
by amrita » Tue Jul 05, 2016 12:09 am
Thank you so much, it worked...
)
-
amrita
- Rookie
-
- Posts: 2
- Joined: Jun 13, 2016
- Reputation: 0
- Excel Version: 2013
Return to General Excel Questions
Who is online
Users browsing this forum: Google [Bot], Google Adsense [Bot] and 70 guests