View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
loren.pottinger loren.pottinger is offline
external usenet poster
 
Posts: 34
Default LEFT Worksheet function

=IF(LEFT(G7,2) = 17,"Dep", "Amort")

I constructed the above function to return Dep if the first two digits
starting from the leftmost digit in cell G7 is 17 and return Amort
otherwise, please help. This formula looks so right to me.