T
twm145
Ive got a table of loss coefficients that are dependent on transition angle,
and the ratio A2/A1.
The angles are used as column headers.
The ratios in the table are row headers.
10 15 20 30 45 60 90 120 150 180
0.1
0.17
0.25
0.5
1
2
4
10
16
The ratio A2/A1 almost never exactly matches those given in the table so I
need a way to round a given A2/A1 ratio to the closet value in the column.
I'm like to modify the following equation to do this:
==OFFSET($AK$29,MATCH(AO24,$AK$30:$AK$38,0),MATCH(AO23,$AL$29:$AU$29,0))
and the ratio A2/A1.
The angles are used as column headers.
The ratios in the table are row headers.
10 15 20 30 45 60 90 120 150 180
0.1
0.17
0.25
0.5
1
2
4
10
16
The ratio A2/A1 almost never exactly matches those given in the table so I
need a way to round a given A2/A1 ratio to the closet value in the column.
I'm like to modify the following equation to do this:
==OFFSET($AK$29,MATCH(AO24,$AK$30:$AK$38,0),MATCH(AO23,$AL$29:$AU$29,0))