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