ExcelBanter - Formulae Help, should be easy...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulae Help, should be easy... (https://www.excelbanter.com/excel-worksheet-functions/115751-formulae-help-should-easy.html)

legs

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

Teethless mama

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

JMB

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

All times are GMT +1. The time now is 07:54 AM.