G
got questions via OfficeKB.com
In a "protected" Word2000 form template using Tables:
I have a drop down list in a Cell containing only 5 items: 1, 2, 3, 4 and 5
When someone clicks on the dropdown and selects one of the numbers, I want to
place a numeric value represented by the number in the dropdown in another
column. This value will ultimately be totaled in a column at the bottom of
the form. This is replicated 25 times on the form, so would like to use cell
references in the formula.
Example: IFB1=1,0.00,0.00 IFB1=2,0.25,0.00 IF B1=3,0.50,0.00 IF B1=4,0.75,0.
00 IF B1=5,1.00,0.00
Basically: IF, THEN, ELSE - I understand the concept, just don't know where
quotes, brackets and commas should go so Word interprets it correctly.
Can this be written as a nested IF statement? I believe it falls under the 7
items rule. The cell reference in the formula would have to be changed for
each of the 25 instances in the table.
Help in constructing this so it works would be appreciated....
My thanks and Best regards
I have a drop down list in a Cell containing only 5 items: 1, 2, 3, 4 and 5
When someone clicks on the dropdown and selects one of the numbers, I want to
place a numeric value represented by the number in the dropdown in another
column. This value will ultimately be totaled in a column at the bottom of
the form. This is replicated 25 times on the form, so would like to use cell
references in the formula.
Example: IFB1=1,0.00,0.00 IFB1=2,0.25,0.00 IF B1=3,0.50,0.00 IF B1=4,0.75,0.
00 IF B1=5,1.00,0.00
Basically: IF, THEN, ELSE - I understand the concept, just don't know where
quotes, brackets and commas should go so Word interprets it correctly.
Can this be written as a nested IF statement? I believe it falls under the 7
items rule. The cell reference in the formula would have to be changed for
each of the 25 instances in the table.
Help in constructing this so it works would be appreciated....
My thanks and Best regards