Formula not working [Solved/Closed]

jinoob 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Mar 20, 2013 at 09:04 AM - Latest reply: Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen
- 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.

See more 

13 replies

Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Mar 20, 2013 at 06:04 PM
0
Thank you
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 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Mar 22, 2013 at 08:49 AM
0
Thank you
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 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Mar 22, 2013 at 05:58 PM
0
Thank you
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 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Mar 23, 2013 at 12:14 AM
0
Thank you
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 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - 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
Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Mar 26, 2013 at 03:24 PM
0
Thank you
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:

http://www.speedyshare.com/

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 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Mar 27, 2013 at 06:43 AM
0
Thank you
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 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Mar 27, 2013 at 01:48 PM
0
Thank you
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:

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

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

Please revert for clarification.
jinoob 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Apr 3, 2013 at 01:58 AM
0
Thank you
Sir,
Please download file from this link.
deleted as requested by Zohaib
Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Apr 3, 2013 at 04:26 AM
0
Thank you
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 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Apr 6, 2013 at 02:50 AM
0
Thank you
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 13 Posts Monday February 18, 2013Registration date October 1, 2013 Last seen - Apr 17, 2013 at 08:23 AM
0
Thank you
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 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Apr 18, 2013 at 12:50 AM
0
Thank you
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.