Eric,

That sounds less like an IF and more like a VLOOKUP type of problem. See
help for VLOOKUP - just don't use a fourth parameter (or set it to True).

HTH,
Bernie
MS Excel MVP


"Eric" wrote in message
...
I am a pilot and am trying to put together a conditional equation
concerning
aircraft weight and balance data. I want Excel to determine if a SUM falls
within a range of weights and then display the applicable forward and aft
moments, based on the SUM figure. I currently use a three-column paper
chart
that gives me weights in 21 different 50 pound ranges (in one column),
then
gives me the applicable forward and aft moments for each weight in the
other
two columns. I am trying to make a spreadsheet for my Palm Pilot (using
Documents-to-Go which interfaces with Excel 2000). I've been beating my
brains out trying to develop an IF equation, but haven't had any luck. Can
anyone help me please?