**Question description:**

*This user has given permission to use the problem statement for this blog.*

If the percentage of students is less than 75% in excel sheet, then what formula can be determined by how many persents will be required for 80% percentage

Solved by E. Y. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
01/08/2018 - 09:43

Welcome to ExcelChat!

User
01/08/2018 - 09:43

If the percentage of students is less than 75% in excel sheet, then what formula can be determined by how many persents will be required for 80% percentage

Excelchat Expert
01/08/2018 - 09:43

Could you show an example of data based on which we will work?

Excelchat Expert
01/08/2018 - 09:44

Column c is the students names?

User
01/08/2018 - 09:46

yes

Excelchat Expert
01/08/2018 - 09:47

Okay, so you need to know how many days they should visit in order to have 80%?

User
01/08/2018 - 09:47

yes

Excelchat Expert
01/08/2018 - 09:47

In total or extra days they should visit?

User
01/08/2018 - 09:48

please explain formulas

Excelchat Expert
01/08/2018 - 09:48

For example, sonu right now visited 1 day out of 4

Excelchat Expert
01/08/2018 - 09:48

Do you need to know how many days he should visit in total to have 80%?

User
01/08/2018 - 09:48

ok

User
01/08/2018 - 09:48

yes

Excelchat Expert
01/08/2018 - 09:49

Okay, I will make a solution for you

User
01/08/2018 - 09:49

please explain what i do?

Excelchat Expert
01/08/2018 - 09:50

You just have to multiply 80% by the total days (which is sum of P and A)

Excelchat Expert
01/08/2018 - 09:50

So in order to have at least 80% of presence, the student should visit at least 4 days (do you want me to add the round up?)

User
01/08/2018 - 09:50

but I2 and j2 are blank

User
01/08/2018 - 09:51

yes

Excelchat Expert
01/08/2018 - 09:51

what does it mean if they are blank?

Excelchat Expert
01/08/2018 - 09:52

You can explain me where I can take the total number of days and I will change the formula based on it

User
01/08/2018 - 09:52

i give me answer only

Excelchat Expert
01/08/2018 - 09:53

At this point I count the total number of days from total of A or P

Excelchat Expert
01/08/2018 - 09:53

Does it solve your problem?

User
01/08/2018 - 09:54

no

Excelchat Expert
01/08/2018 - 09:55

Could you explain what is wrong?

User
01/08/2018 - 09:55

what is your answer

Excelchat Expert
01/08/2018 - 09:55

the answer is 4, since it is impossible to visit 3.2 days, it is rounded up

Excelchat Expert
01/08/2018 - 09:57

if you add extra days (i and J), the result is changed

User
01/08/2018 - 09:57

In excel sheets, if the percentages of students are less than 75% then what formula can be determined from how many days will be for 80% parsection

Excelchat Expert
01/08/2018 - 09:58

This formula answers your question

Excelchat Expert
01/08/2018 - 09:58

=roundup(0.8*sum(K2:L2))

User
01/08/2018 - 09:58

CAN I CALL YOU

Excelchat Expert
01/08/2018 - 09:58

if you need something else, please specify it

Excelchat Expert
01/08/2018 - 09:58

No, sorry, we can only use the chat

Excelchat Expert
01/08/2018 - 09:59

It is forbidden for us to use any other way of communication

Excelchat Expert
01/08/2018 - 10:00

You can try explaining why this result is not the one you were looking for

Excelchat Expert
01/08/2018 - 10:00

I will quickly change the formulas and you will have the right result

Excelchat Expert
01/08/2018 - 10:00

You can provide an example which number did you expect to get in this situation

Excelchat Expert
01/08/2018 - 10:02

I have created also a formula of extra days to achieve the 80%

Excelchat Expert
01/08/2018 - 10:02

in column P

Excelchat Expert
01/08/2018 - 10:02

Wish you a good day!