Excel If function I think
Closed
Kris
-
Dec 30, 2009 at 12:47 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 30, 2009 at 11:40 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 30, 2009 at 11:40 PM
Related:
- Excel If function I think
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel apk for pc - Download - Spreadsheets
- Find function on mac - Guide
- Kernel for excel - Download - Backup and recovery
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 30, 2009 at 11:40 PM
Dec 30, 2009 at 11:40 PM
try this formula in C1 and copy C1 down
=IF(LEFT(A1,1)="7",LEFT(B1,10),IF(LEFT(A1,2)="01",LEFT(B1,8),IF(LEFT(A1,2)="00",LEFT(B1,7),"")))
=IF(LEFT(A1,1)="7",LEFT(B1,10),IF(LEFT(A1,2)="01",LEFT(B1,8),IF(LEFT(A1,2)="00",LEFT(B1,7),"")))