David, Rounding to the nearest would work. What I need the formula to do is
look up a cell value A12 (for example), reference that value in the WT
column, then match a cell value in A13 (example), reference that value in CG
column, then find the match KIAS value.
Forgive my ignorance as I'm learning Excel on the fly here...thanks for the
help!
2479.0 (A12) 40.2 (A13)
STALL SPEEDS
WT CG KIAS
2300 40.9 44
2300 39 46
2300 37 47
2300 35 48
2300 33 49
2350 40.9 44
2350 39 45
2350 37 47
2350 35 48
2350 33 49
2400 43.5 44
2400 40.9 45
2400 39 46
2400 37 47
2400 35 48
2400 33 49
2450 43.5 44
2450 40.9 45
2450 39 47
2450 37 48
2450 35 49
2450 33 49
2500 43.5 45
2500 40.9 46
2500 39 47
2500 37 48
2500 35 49
2500 33 49
2550 43.5 45
2550 40.9 47
2550 39 48
2550 37 49
2550 35 49
2550 33 50
2600 43.5 46
2600 40.9 48
2600 39 48
2600 37 49
2600 35 49
2600 33 50
2650 43.5 47
2650 40.9 48
2650 39 49
2650 37 49
2650 35 49
2650 33 50
2700 43.5 48
2700 40.9 49
2700 39 49
2700 37 49
2700 35 50
2700 33 50
2750 43.5 48
2750 40.9 49
"David Biddulph" wrote:
That doesn't sound like a chart in the Excel sense of the word. It sounds
more like a lookup table problem. You say you need the formula to round;
do you mean that on each of the lookups you want to round down, or round up,
or round to the nearest? ... or do you want to interpolate and round the
results?
You'll find most of the relevant functions at
http://office.microsoft.com/en-us/ex...%20fun ctions
--
David Biddulph
"TestPilot6" wrote in message
...
To provide some more background to what I'm trying to do. I need to
intersect a WT then match the CG to produce the KIAS where the WT and CG
are
variables defined in a separate cell. I also need the formula to
round...for
the sake of simplicity.
Ie: WT=2359, CG=39.8, KIAS= ?
WT CG KIAS
2300 40.9 44
2300 39 46
2300 37 47
2300 35 48
2300 33 49
2350 40.9 44
2350 39 45
2350 37 47
2350 35 48
2350 33 49
2400 43.5 44
2400 40.9 45
2400 39 46
2400 37 47
2400 35 48
2400 33 49
2450 43.5 44
2450 40.9 45
2450 39 47
2450 37 48
2450 35 49
2450 33 49
2500 43.5 45
2500 40.9 46
2500 39 47
2500 37 48
2500 35 49
2500 33 49
2550 43.5 45
2550 40.9 47
2550 39 48
2550 37 49
2550 35 49
2550 33 50
2600 43.5 46
2600 40.9 48
2600 39 48
2600 37 49
2600 35 49
2600 33 50
2650 43.5 47
2650 40.9 48
2650 39 49
2650 37 49
2650 35 49
2650 33 50
2700 43.5 48
2700 40.9 49
2700 39 49
2700 37 49
2700 35 50
2700 33 50
2750 43.5 48
2750 40.9 49
2750 39 49
2750 37 49
2750 35 50
2750 33 50
2800 43.5 49
2800 40.9 49
2800 39 49
2800 37 50
2800 35 50
2800 33 50
2850 43.5 49
2850 40.9 50
2850 39 50
2850 37 50
2850 35 50
2850 33 50
2900 43.5 49
2900 40.9 50
2900 39 50
2900 37 50
2900 35 50
2950 33 50
3000 46 49
3000 43.5 50
3000 40.9 51
3000 39 51
3000 37 51
3000 35 51
3000 33 51
3100 46 50
3100 43.5 50
3100 40.9 51
3100 39 51
3100 37 51
3100 35 51
3100 33 51
"TestPilot6" wrote:
I am trying to find a formula to automatically return the x/y
intersection on
a chart to a cell.