COLUMN B
r1 Grant Number
r2 NNX08AE13G S01
r3 NNX07AJ55G S01
r4 NNX08AE20G S03
r5 NNX08AE20G S02
r6 NNX10AF75G


COLUMN H Gives anticipated results
r1 SUPPL?
r2 =(MID(B2,12,1)) checks for supp flag (S)
r3 S
r4 S
r5 S
r6 blank


COLUMN I
r1 WHICH-SUPPL? this column repeats the function in all columns
r2 =MID(B2,13,2)
r3 "
r4 "
r5 "
r6 "


COLUMN J
r1 NOT-SUPPL this column repeats either function in all columns
r2 =if(H2<"S","00")
r3 =IF(H3="S",MID(B3,13,2))
r4 "
r5 "
r6 "


When I first typed in the mid function in Column I,
then copied it to the rest of the column, I got the expected
01, 01, 03, 02 and "false" for the for the row w/o an S but
when I tried to use the if statement, the function is repeated;
Now the mid function won't work at all.

Column J won't work at all.

What is wrong with the functions? or have I set something incorrectly?