Shorten the lengthy formula

SanjayaGarg

New Member
Joined
Nov 10, 2017
Messages
20
Office Version
  1. 2013
Platform
  1. 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’.

Name of faculty
Tenure​
Period​
Joining DateInitial tenure completed onTenure Completed onExtn 1Extn 2Extn 3Extn 4Extn 5Extn 6Extn 7Extn 8Extn 9Extn 1044 days Extn 144 days Extn 244 days Extn 344 days Extn 444 days Extn 544 days Extn 644 days Extn 744 days Extn 844 days Extn 944 days Extn 10
Dr. Anil Dhal01year22-07-202021-07-202121-07-2021
Dr. Anil Kumar Rai01year03-08-202002-08-202102-08-2021
Dr. Ashok Kr. Shah01year04-01-202103-01-202203-01-2022
Dr. Devki Nandan44days17-02-202101-04-202111-08-202102-04-202116-05-202129-06-202115-05-202128-06-202111-08-2021
Dr. Mahesh Chandra44days12-10-202024-11-202015-08-202125-11-202008-01-202121-02-202106-04-202120-05-202103-07-202107-01-202120-02-202105-04-202119-05-202102-07-202115-08-2021
Dr. Narendra Singh01year08-09-202007-09-202107-09-2021
Dr. Priti Agarwal44days06-04-202119-05-202115-08-202120-05-202103-07-202102-07-202115-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
Joined
Jul 4, 2014
Messages
1,482
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
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
Joined
Nov 10, 2017
Messages
20
Office Version
  1. 2013
Platform
  1. Windows
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'.
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top