# Cel Value Formula for MS Excel Office 2000 Microsoft Ms sla excel lic/sa 2yr-1
June 10, 2010 at 15:39:45
Specs: Windows XP
 Can anyone give me some advice with a formula for MS Excel. I have values of 100,200,300,400, etc. to be inserted in cell A1 and based on the selection, I need a corresponding number to be automatically placed in cell B2. This has to do with the weight & balance of an airplane. Cell A1 is the Fuel weight and Cell B1 is the Moment. There are 68 different choices for cell A1. Thank You! See More: Cel Value Formula for MS Excel Office 2000

#1 June 10, 2010 at 16:08:11
 I'm glad you know what your talking about, because I don't.You'll have to be a bit more specific.What does your sheet look like, what cells are you using?values of 100,200,300,400, etc. to be inserted in cell A1 and based on the selection, I need a corresponding number to be automatically placed in cell B2.So if 100 goes in A1, you want 100 in B2?Cell B1 is the MomentDo you mean it's a time cell, like =NOW()?How does that fit into the whole scheme of things?MIKEhttp://www.skeptic.com/

Report •

#2
June 10, 2010 at 16:26:51
 The form I have created has several cells in three columns for various values. Some of the cells I have been able to insert basic formulas (addition, subtraction, etc.) What I need help with is one cell where the pilot will insert the fuel weight in increments of 100 lbs.The Moment is a term for a linear value based on the Arm (distance from the front of the acft). It is a set value based on a weight and the arm.There is a value that corresponds with each 100 lbs. for example:100 = 34751200 = 69502300 = 103004and so on . . to6700 = 22067296790 = 2236955 What I am trying to do is simplify the calculation of the weight and balance form that when a pilot puts in a weight value in a cell labeled "Fuel Weight" a corresponding value of that particular "moment" is automaticaly inserted in the adjacent cell.The Moment value associated with the weight is derived from the airplane flight manual charts. I can send you a copy of the Excel Page that I have been working on if that will help. Hope that clarifies it a little better.

Report •

#3 June 10, 2010 at 17:07:46
 There is a value that corresponds with each 100 lbs. for exampleCan this be calculated, or is it simply a list?100 = 34751200 = 69502300 = 103004How is the differences between the 100 values calculated?MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4 June 10, 2010 at 17:13:16
 You might want to look at this thread, it's a bit old, but does it give you the basics of what your looking for?Is it something we can develop or expand?Don't try the link at the bottom, the page is blank.http://www.eggheadcafe.com/software...MIKEhttp://www.skeptic.com/

Report •

#5
June 10, 2010 at 17:20:56
 It is simply just a list. 100 has set corresponding value. 200 has a set value and so on. No calculations to be done.If A1 is 100 then B1 is a set valueIf A1 is 200 then B1 is a set value etc. Does that make sense?

Report •

#6 June 10, 2010 at 18:35:59
 What I need help with is one cell where the pilot will insert the fuel weight in increments of 100 lbs.Try this:A =VLOOKUP() should work nicely.On Sheet 2 of your workbook, in column A list your weight table:``` A B 1) 100 34751 2) 200 69502 3) 300 103004 4) 6700 2206729 5) 6790 2236955 ```On Sheet 1 cell B1 enter the formula: =VLOOKUP(A1,Sheet2!A1:B5,2)When you enter a weight in Sheet 1, cell A1, this will fetch the corresponding number from Sheet 2, column B.So if you enter 100 in A1, 34751 comes up in B1Will that work for you?MIKE

Report •

#7 June 10, 2010 at 18:40:32
 Put all of your possible A1 values in a list, let's say in C1:C68.Put all of your corresponding values in a list, let's say in D1:D68.Put a Data Validation Drop Down list in A1, populated with the values from C1:C68.In B1, put this formula:=VLOOKUP(A1,\$C\$1:\$D\$68,2,0)This will lookup the value selected by the A1 Drop Down in C1:C68 and return the corresponding value from the list in D1:D68.

Report •

#8 June 10, 2010 at 18:49:50
 Like the addition of a dropdown, makes things harder to screw up. Wish I had thought of it.MIKEhttp://www.skeptic.com/

Report •

#9
June 10, 2010 at 19:06:47
 Thanks Folks! I'll try that tonight and see if I can't get this to work. I really appreciate the time you spent.

Report •

#10
June 10, 2010 at 19:29:05
 I just tried the suggestion you gave with the dropdown and it works great. Thank You Very Much! I never would have figured that out. Like I said, I am new to the Excel functions other than basic formulas.Now I have to research how to protect just certain cells so pilots using the form don't change any of the formulas or valuses within those cells.

Report •

#11 June 11, 2010 at 03:10:19
 It's all in the Help files.If you need help protecting cells, please start a new thread with a new question.

Report • 