SanjayaGarg
New Member
- Joined
- Nov 10, 2017
- Messages
- 25
- Office Version
- 2013
- Platform
- Windows
Hi! written this simple formula which is lengthy. I want some correction in this, if possible :
1. Want to reduce the size of this formula <=IF(D2="","",IF(G2="",E2,IF(H2="",(G2+B2)-1,IF(I2="",(H2+B2)-1,IF(J2="",(I2+B2)-1,IF(K2="",(J2+B2)-1,IF(L2="",(K2+B2)-1,IF(M2="",(L2+B2)-1,IF(N2="",(M2+B2)-1,IF(O2="",(N2+B2)-1,IF(P2="",(O2+B2)-1,(P2+B2)-1)))))))))))>
2. If ‘Period’ is “year” and ‘Extn…..’ is not blank then ‘Tenure’ be added to year of ‘Joining date’, If ‘Period’ is “days” and ‘Extn…..’ is not blank then ‘Tenure’ be added to days of ‘Joining date’ otherwise ‘Tenure’ be added to month of ‘Joining date’.
1. Want to reduce the size of this formula <=IF(D2="","",IF(G2="",E2,IF(H2="",(G2+B2)-1,IF(I2="",(H2+B2)-1,IF(J2="",(I2+B2)-1,IF(K2="",(J2+B2)-1,IF(L2="",(K2+B2)-1,IF(M2="",(L2+B2)-1,IF(N2="",(M2+B2)-1,IF(O2="",(N2+B2)-1,IF(P2="",(O2+B2)-1,(P2+B2)-1)))))))))))>
2. If ‘Period’ is “year” and ‘Extn…..’ is not blank then ‘Tenure’ be added to year of ‘Joining date’, If ‘Period’ is “days” and ‘Extn…..’ is not blank then ‘Tenure’ be added to days of ‘Joining date’ otherwise ‘Tenure’ be added to month of ‘Joining date’.
Name of faculty | Tenure | Period | Joining Date | Initial tenure completed on | Tenure Completed on | Extn 1 | Extn 2 | Extn 3 | Extn 4 | Extn 5 | Extn 6 | Extn 7 | Extn 8 | Extn 9 | Extn 10 | 44 days Extn 1 | 44 days Extn 2 | 44 days Extn 3 | 44 days Extn 4 | 44 days Extn 5 | 44 days Extn 6 | 44 days Extn 7 | 44 days Extn 8 | 44 days Extn 9 | 44 days Extn 10 |
Dr. Anil Dhal | 01 | year | 22-07-2020 | 21-07-2021 | 21-07-2021 | ||||||||||||||||||||
Dr. Anil Kumar Rai | 01 | year | 03-08-2020 | 02-08-2021 | 02-08-2021 | ||||||||||||||||||||
Dr. Ashok Kr. Shah | 01 | year | 04-01-2021 | 03-01-2022 | 03-01-2022 | ||||||||||||||||||||
Dr. Devki Nandan | 44 | days | 17-02-2021 | 01-04-2021 | 11-08-2021 | 02-04-2021 | 16-05-2021 | 29-06-2021 | 15-05-2021 | 28-06-2021 | 11-08-2021 | ||||||||||||||
Dr. Mahesh Chandra | 44 | days | 12-10-2020 | 24-11-2020 | 15-08-2021 | 25-11-2020 | 08-01-2021 | 21-02-2021 | 06-04-2021 | 20-05-2021 | 03-07-2021 | 07-01-2021 | 20-02-2021 | 05-04-2021 | 19-05-2021 | 02-07-2021 | 15-08-2021 | ||||||||
Dr. Narendra Singh | 01 | year | 08-09-2020 | 07-09-2021 | 07-09-2021 | ||||||||||||||||||||
Dr. Priti Agarwal | 44 | days | 06-04-2021 | 19-05-2021 | 15-08-2021 | 20-05-2021 | 03-07-2021 | 02-07-2021 | 15-08-2021 |