Shorten the lengthy formula

[SanjayaGarg]

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

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

 

[jorismoerings]

Hi,

Without knowing what the cell references are, where the mentioned formula is placed, etc. this is chasing ghosts.
Can you provide us with better info and if possible use XL2BB to be located at this link

 

[SanjayaGarg]

Hi,

Without knowing what the cell references are, where the mentioned formula is placed, etc. this is chasing ghosts.
Can you provide us with better info and if possible use XL2BB to be located at this link

Sorry for mistake. The formula has been placed in F2:F....... 'Tenure completed on'.