# Excel - IF Function Problem - Expert Solution

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