On your formula, you just need to remove the A1 in the middle, eg.
=IF(LEFT(A1)="1",LEFT(A1 +1),IF(LEFT(A1)="2",LEFT(A1+1),A1))
or shorten to..
=IF(OR(LEFT(A1)={"1","2"}),LEFT(A1+1),A1)
On your formula, you just need to remove the A1 in the middle, eg.
=IF(LEFT(A1)="1",LEFT(A1 +1),IF(LEFT(A1)="2",LEFT(A1+1),A1))
or shorten to..
=IF(OR(LEFT(A1)={"1","2"}),LEFT(A1+1),A1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks