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
|