what's wrong with this function?

D

DogmaDot

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

move multiple columns into single set of columns 1
Adding groups of resources to groups of tasks 9
How to identify staff who has deptcode change 4
Inserting text from external file into cells. 0
change InputTitle and InputMessage in columns from row 2 thru 1000 0
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Do NOt Know Which Function to Use 1
VBA to set AutoFilter to List all rows with same values in column? 2

Top