Comparing the first x numbers in a cell
Closed
nephetius
-
May 14, 2009 at 09:22 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 03:00 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 19, 2009 at 03:00 AM
Related:
- Comparing the first x numbers in a cell
- If a cell has text then return value ✓ - Excel Forum
- What function can automatically return the value in cell c77 - Excel Forum
- Clear only the formatting from the selected cell - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
May 19, 2009 at 03:00 AM
May 19, 2009 at 03:00 AM
Here is the solution ....... you can enter your calculations there ....... suppose your code is in Cell A1 then by using this formula in B1 or C1 you can pick up first 3 char and then can do your calculations ...
=IF(LEFT(A1,3)="125","Do the calculation",IF(LEFT(A1,3)="164","do the office calculation"))
=IF(LEFT(A1,3)="125","Do the calculation",IF(LEFT(A1,3)="164","do the office calculation"))
