LEFT Worksheet function
Try:
=IF(VALUE(LEFT(G7,2) )= 17,"Dep", "Amort")
if G7 is text
=IF(LEFT(G7,2) = "17","Dep", "Amort")
HTH
"loren.pottinger" wrote:
=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.
|