View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
legs legs is offline
external usenet poster
 
Posts: 4
Default 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