| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae Help, should be easy...
Hi! I need a formula to look at the left 2 digits of a number in a given
cell. If the number shows "61" it is to return "AU", if it is "62" it is to return "NZ". If it is blank it should show "". Is anyone able to help me with this? Thx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulae Help, should be easy...
=IF(A1="","",IF(A1=61,"AU",IF(A1=62,"NZ","else another value")))
"legs" wrote: Hi! I need a formula to look at the left 2 digits of a number in a given cell. If the number shows "61" it is to return "AU", if it is "62" it is to return "NZ". If it is blank it should show "". Is anyone able to help me with this? Thx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulae Help, should be easy...
Another suggestion:
=IF(A1="","",LOOKUP(--LEFT(A1,2),{0,61,62},{"","AU","NZ",""})) numbers below 61 and above 62 return "", modify if needed. "legs" wrote: Hi! I need a formula to look at the left 2 digits of a number in a given cell. If the number shows "61" it is to return "AU", if it is "62" it is to return "NZ". If it is blank it should show "". Is anyone able to help me with this? Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
| Using the results of formulae between different spreadsheets. | Excel Worksheet Functions | |||
| Change to formulae | Excel Worksheet Functions | |||
| XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) | |||
| vlookup change column index position - without changing formulae | Excel Worksheet Functions | |||
Linear Mode
