Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Equations in Excel
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? |
#2
|
|||
|
|||
Conditional Equations in Excel
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? |
#3
|
|||
|
|||
Conditional Equations in Excel
Sounds like you should look at the vlookup function rather than a complicated
if. The 'table range' argument of the vlookup function will probably be exactly your three-column paper chart. You'll want to omit the fourth argument of the vlookup to get a range lookup, and be sure that your formula references the table with absolute cell references ($a$1:$c$21, rather than a1:c21). --Bruce "Eric" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Use conditional formating to incicate blank cells in excel | Excel Worksheet Functions | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions |