# Formula not working

Solved/Closed
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013 - Mar 20, 2013 at 09:04 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 18, 2013 at 12:50 AM
Hello,

Q16 to Q20 cells contains values from 0 to 10 (it came from LOOKUP Function). I need to get a result in D24 from the cells Q16 to Q20 as ,"QUALIFIED FOR ADMISSION TO HIGHER CLASSES"/"ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE". I used the following formula for the same. =IF(MIN(Q16:Q20)>=4,"QUALIFIED FOR ADMISSION TO HIGHER CLASSES",IF(MIN(Q16:Q20)<4,"ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE")). But it is not working properly. I think it may be because of the formula I used in the cells (Q16:20) to get the values 0 to 10 as mentioned above. How to solve this issue? Please help me.

## 12 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 20, 2013 at 06:04 PM
Hi jinoob,

I tried to duplicate the sheets you have described, using Microsoft Excel 2010 and it works fine. I have uploaded the sample sheet here, check if it helps:

http://speedy.sh/82mgJ/ResultsFile.xlsx

Your formula is D24 is really nice. It might help me in future.

Do reply with results.
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013
Mar 22, 2013 at 08:49 AM
Sir,
I asked the doubt to develop students academic profile. The entire data which I have done is already in excel 2010. If I use the FUNCTION (which I send yesterday) in independent files, it is working properly and the problem is it is not working after giving link to other files. That may be because of the data comes to the student profile which i created is from different excel files (it is also a macro enabled file for updating student photos). Since result from that FUNCTION is very much essential for my profile, how do i get a correct result? Could you please help me out?
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 22, 2013 at 05:58 PM
Hi jinoob,

I would like to know what error (such as #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) you receive in cell D4. Or, it simply displays as blank?

Please do write back to us.
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013
Mar 23, 2013 at 12:14 AM
In cell D24, the result is coming as "ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE" instead of "QUALIFIED FOR ADMISSION TO HIGHER CLASSES". If the values in the cells are 4 or above I should get the result as "QUALIFIED FOR ADMISSION TO HIGHER CLASSES" and if any one value in the cells are less than 4, the result should be "ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE". Moreover, if we select the cells from Q16 to Q20 and apply 'auto sum', its not working - only the formula is displaying and blinking above the cell. At the same time if we give the command Q16+Q17+Q18+Q19+Q20, then the correct result is coming. The functions like "Auto Sum, MIN, MAX" etc are not working in that cell. What will be the reason for the same? If we can find a solution for that, I think the above problem also can be rectified.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 23, 2013 at 07:29 AM
@jinoob
Why not post a sample book like Zohaib did. Easier to see whats the issue like that

Didn't find the answer you are looking for?

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 26, 2013 at 03:24 PM
Hi jinoob,

Sorry for the delayed response. With permission from rizvisa1 I would like to work with you again. rizvisa1 has pointed it correctly that you should upload a sample sheet to:

https://authentification.site

Everything works fine with my sheet, also when I added a VLOOKUP() worksheet function in cells from Q16 to Q20 the results are okay. I am uploading my file again, please check:

http://speedy.sh/Jau4C/ResultsFile.xlsx

Please do write back to us.
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013
Mar 27, 2013 at 06:43 AM
Sir,
As per your instruction, I uploaded the file. Please download it from the following link. [deleted as requested by Zohaib-2012-2013.] I have uploaded 3 excel files and folder containing photos which i used for the working of the above file. The data coming to these excel files are from other files, which are not uploaded. Actually, we have worked with one software team for one year for developing a software for making Performance profile of the above type. They have almost succeeded in making the profile. Though they have developed the software by taking help from us, they asked for a huge amount as implementation charge. We were ready to give the payment, but the problem was the continuous errors in the results. So we dropped the same and we started working by our own knowledge and finally we reached up to the above stage.
After going through the above file kindly tell me your suggestions to improve. I have a few more doubts to be clarified.
Now i am selecting a student name, then clicking "Update Photo" button for generating one student profile. There are 40 to 43 students in a division and each time i do the same procedure for generating the profile. I would like to know whether there is any VBA (macro) for generating entire profiles at a stretch to pdf format.
Since the data belongs to a school, I humbly request you to avoid displaying the link in the forum. Expecting an early reply,
Thank You & Regards.
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Mar 27, 2013 at 01:48 PM
Hi jinoob,

I tried opening the link you have provided but I receive the error shown in the following image:

http://s10.postimg.org/itv9rs2eh/Error01.jpg

As you mentioned I should not upload the final file in the forum, it will be difficult to work this out. However, I would like to help you with other suggestion. I worked with one of the other users in this forum creating some applications for displaying student profile and images, please check the below mentioned link and see if this helps:

https://ccm.net/forum/affich-675372-display-image-on-picturebox-using-the-image-path-stored-on-db

https://ccm.net/forum/affich-673444-saving-image-path-to-access-database-and-retrieving-images

Please revert for clarification.
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013
Apr 3, 2013 at 01:58 AM
Sir,
deleted as requested by Zohaib
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 3, 2013 at 04:26 AM
Hi jinoob,

I have downloaded the file. I am working on this. Once a find a fix I will upload the sample file and provide you the link.
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 6, 2013 at 02:50 AM
Hi jinoob,

With a little bit of effort I changed the formula in "D24" of the sheet "Page 2 & 3" and its working fine now.

Replace:

=IF(MIN(Q16:Q20)>=4,"QUALIFIED FOR ADMISSION TO HIGHER CLASSES",IF(MIN(Q16:Q20)<4,"ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE"))

With:

=IF((MIN(VALUE(Q16),VALUE(Q17),VALUE(Q18),VALUE(Q19),VALUE(Q20)))>=4,"QUALIFIED FOR ADMISSION TO HIGHER CLASSES",IF((MIN(VALUE(Q16),VALUE(Q17),VALUE(Q18),VALUE(Q19),VALUE(Q20)))<4,"ELIGIBLE FOR IMPROVEMENT OF PERFORMANCE"))

Do reply with results.
jinoob Posts 13 Registration date Monday February 18, 2013 Status Member Last seen October 1, 2013
Apr 17, 2013 at 08:23 AM
Dear Sir,
I applied the new formula and it is working. Now I am extremely happy with the result. Thanks a lot for the constant support. Sir, if you don't mind kindly give me the suggestions to improve the working system behind the "Performance Profile". Once again let me thank you for your timely support.
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 18, 2013 at 12:50 AM
Hi jinoob,

I am glad I could help you. It is great to hear that the formula finally worked. I would like to say that your "Performance Profile" is an incredible work in Excel. Next level of improvement is to have this entire project re-created using a front end application and a back-end database. For this you might need to write a computer program.