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!