# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.