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
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 18, 2013 at 12:50 AM
Related:
- Formula not working
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
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
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.
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
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?
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
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.
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
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
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
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?
Ask a question
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
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.
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
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.
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
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.
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
Apr 3, 2013 at 01:58 AM
Sir,
Please download file from this link.
deleted as requested by Zohaib
Please download file from this link.
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
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.
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
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.
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
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.
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
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.
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.
