LEFT Worksheet function
Try:
=IF(LEFT(G7,2) = "17","Dep", "Amort")
or
=IF(--LEFT(G7,2) = 17,"Dep", "Amort")
Regards
Trevor
"loren.pottinger" wrote in message
ps.com...
=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.
|