LEFT Worksheet function
How about =IF(LEFT(G7,2)="17","Dep","Amort")
Dave
--
Brevity is the soul of wit.
"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.
|