Decision table help

  • Thread starter Thread starter bartmacl
  • Start date Start date
B

bartmacl

Hello, I am making a decision table and I could use some help with formulas
to make the data entry easier. Any help or links would be appreciated. I
have experimented with the offset function unsuccessfully.

1) In cells B1, C1, D1, etc. I have choices A, B, C, etc.
2) In cells A2, A3, A4, etc. I have the same choices listed (A, B, C, etc.).
In other words, cells B1 and A2 have the same value (choice A).
3) I do not enter values in cells B2, C3, D4, E5, etc.
4) I then compare A2 (choice A) to C2 (value B) and enter one of the
following values based on how choice A compares to choice B (1/7 (
exponentially worse), 1/5 (much worse), 1/3 (worse), 1 (equal), 3 (better),
5 (much better) and 7 (exponentially better).
5) The tricky part is I would like the complimentary value that I enter in
C2 (lets say "7") to be entered in cell B3 (1/7).

Thanks in advance for whatever help you can provide.
 
Perhaps try something along these lines:

Assuming that your decision table is in A1:E5
with the set-up as described

Select B3:B5

Put in the formula bar: =1/TRANSPOSE(C2:E2)

Array-enter the formula
[ i.e. Hold down CTRL + SHIFT, press ENTER ]

The same formula, with the curly braces {} inserted by Excel:
{=1/TRANSPOSE(C2:E2)}
will appear in each cell in B3:B5

Format B3:B5 as fraction via:
Format > Cells > Fraction (Up to one digit)

That should give you the desired results in B3:B5
depending on what's entered in C2:E2
--
Repeat likewise the construct above for the rest of table:

Select C4:C5
Put in the formula bar: =1/TRANSPOSE(D3:E3)
Array-enter the formula
Format C4:C5 as fraction

Select D5
Put in the formula bar: =1/TRANSPOSE(E4)
Array-enter the formula
Format D5 as fraction
 
Max ...thanks very much, works great!

bartmacl

Max said:
Perhaps try something along these lines:

Assuming that your decision table is in A1:E5
with the set-up as described

Select B3:B5

Put in the formula bar: =1/TRANSPOSE(C2:E2)

Array-enter the formula
[ i.e. Hold down CTRL + SHIFT, press ENTER ]

The same formula, with the curly braces {} inserted by Excel:
{=1/TRANSPOSE(C2:E2)}
will appear in each cell in B3:B5

Format B3:B5 as fraction via:
Format > Cells > Fraction (Up to one digit)

That should give you the desired results in B3:B5
depending on what's entered in C2:E2
--
Repeat likewise the construct above for the rest of table:

Select C4:C5
Put in the formula bar: =1/TRANSPOSE(D3:E3)
Array-enter the formula
Format C4:C5 as fraction

Select D5
Put in the formula bar: =1/TRANSPOSE(E4)
Array-enter the formula
Format D5 as fraction

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---
bartmacl said:
Hello, I am making a decision table and I could use some help with formulas
to make the data entry easier. Any help or links would be appreciated. I
have experimented with the offset function unsuccessfully.

1) In cells B1, C1, D1, etc. I have choices A, B, C, etc.
2) In cells A2, A3, A4, etc. I have the same choices listed (A, B, C, etc.).
In other words, cells B1 and A2 have the same value (choice A).
3) I do not enter values in cells B2, C3, D4, E5, etc.
4) I then compare A2 (choice A) to C2 (value B) and enter one of the
following values based on how choice A compares to choice B (1/7 (
exponentially worse), 1/5 (much worse), 1/3 (worse), 1 (equal), 3 (better),
5 (much better) and 7 (exponentially better).
5) The tricky part is I would like the complimentary value that I enter in
C2 (lets say "7") to be entered in cell B3 (1/7).

Thanks in advance for whatever help you can provide.
Click to expand...
Click to expand...
 
Back
Top