Question description:
This user has given permission to use the problem statement for this
blog.
I need to deduct late marks for employees. if late marks >4, 0.5, >5, 1, >6 1.5, >7 2 and so so...how can help to write an excel formula on this
Solved by S. H. in 22 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
23/03/2018 - 07:23
hello
Excelchat Expert
23/03/2018 - 07:23
Welcome to Got it pro
Excelchat Expert
23/03/2018 - 07:25
For the given issue we can use IF formula
Excelchat Expert
23/03/2018 - 07:28
Hello.... Are you there?
Excelchat Expert
23/03/2018 - 07:28
Please explain the issue in detail.
Excelchat Expert
23/03/2018 - 07:29
You say if late marks >4, 0.5, >5, 1, >6 1.5, >7 2 and so so.. What is the last number for this 'so so'....
Excelchat Expert
23/03/2018 - 07:29
What is 4,5,6,7 and do we have to deduct 0.5, 1, 1.5 ......
Excelchat Expert
23/03/2018 - 07:29
from which value do we have to deduct them?
Excelchat Expert
23/03/2018 - 07:30
Please share sheet with relevant details for framing the formula
User
23/03/2018 - 07:31
hi
User
23/03/2018 - 07:32
yes
User
23/03/2018 - 07:32
this is correct what you said
User
23/03/2018 - 07:32
You say if late marks >4, 0.5, >5, 1, >6 1.5, >7 2 and so so.. What is the last number for this 'so so'....
User
23/03/2018 - 07:32
4,5,6,7 is number of late marks
User
23/03/2018 - 07:32
0.5, 1, 1.5 are days to be deducted
User
23/03/2018 - 07:32
4 for half day
Excelchat Expert
23/03/2018 - 07:33
okay
User
23/03/2018 - 07:33
5 lm 1 day deduction etc
User
23/03/2018 - 07:33
i used if formula for now
Excelchat Expert
23/03/2018 - 07:33
That menas with each half day there will be an increase with 1 marks.
Excelchat Expert
23/03/2018 - 07:33
can you please share the sheet
User
23/03/2018 - 07:34
each late mark increase in half day
User
23/03/2018 - 07:34
=+IF((AL3)<3,"0")+IF((AL3)>=4,"0.5","0")+IF((AL3)>=5,"0.5","0")+IF((AL3)>=6,"0.5","0")+IF((AL3)>=7,"0.5","0")+IF((AL3)>=8,"0.5","0")++IF((AL3)>=9,"0.5","0")++IF((AL3)>=10,"0.5","0")
User
23/03/2018 - 07:34
i have used this formula for caculations
User
23/03/2018 - 07:34
ed a short one
User
23/03/2018 - 07:34
need a short one
User
23/03/2018 - 07:34
as this is limited
Excelchat Expert
23/03/2018 - 07:34
It would help me get an accurate formula
Excelchat Expert
23/03/2018 - 07:34
limited to what?
User
23/03/2018 - 07:35
formula
User
23/03/2018 - 07:35
limited
Excelchat Expert
23/03/2018 - 07:35
okay
Excelchat Expert
23/03/2018 - 07:35
Please share the sheet.
User
23/03/2018 - 07:35
i ahve not prepared the sheet as yet
User
23/03/2018 - 07:35
looking for formula
Excelchat Expert
23/03/2018 - 07:36
Could you share the file on which you are working?
User
23/03/2018 - 07:36
i ahve shared you th formula
User
23/03/2018 - 07:36
you can work on that
User
23/03/2018 - 07:36
and take random numbers ofr late marks
Excelchat Expert
23/03/2018 - 07:36
Let me check it.
Excelchat Expert
23/03/2018 - 07:38
The formula is working and seems to be correct
Excelchat Expert
23/03/2018 - 07:38
What is that you want me to work on?
Excelchat Expert
23/03/2018 - 07:39
You have already written the correct formula.
Excelchat Expert
23/03/2018 - 07:40
Or do you want to make it unlimited.
Excelchat Expert
23/03/2018 - 07:40
i.e. even if you type 20 its give you the answer?
Excelchat Expert
23/03/2018 - 07:41
You can use simple formula I have shared on the shared document.
Excelchat Expert
23/03/2018 - 07:44
We would not require complex If formula. Just a simple calculation would do. I hope this would resolve your issue.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.