# Shorten the lengthy formula

#### SanjayaGarg

##### New Member
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

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### jorismoerings

##### Well-known Member
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

##### New Member
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'.

Replies
7
Views
158
Replies
1
Views
179
Replies
2
Views
409
Replies
3
Views
99
Replies
2
Views
60

1,147,479
Messages
5,741,392
Members
423,657
Latest member
Medrok2021

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back