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

Report •


#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 Moment

Do you mean it's a time cell, like =NOW()?

How does that fit into the whole scheme of things?

MIKE

http://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 = 34751
200 = 69502
300 = 103004
and so on . . to
6700 = 2206729
6790 = 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 example

Can this be calculated, or is it simply a list?
100 = 34751
200 = 69502
300 = 103004
How is the differences between the 100 values calculated?

MIKE

http://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...

MIKE

http://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 value
If 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 B1

Will that work for you?

MIKE

http://www.skeptic.com/


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.

MIKE

http://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 •


Ask Question