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
- Clear only the formatting from the selected cell (leaving the content) - Guide
- If cell contains date then return value ✓ - Office Software Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Cell phone battery reset code - 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"))
