New user with a help request

[Coastie]

I just found your site via google. It appears I'm in the right place!

I'm trying to create a simple drop down menu with 2 choices.

Choice #1 text will produce a value of 22
Choice #2 text will produce a value of 24

The value will then be converted by another formula (below).

I'd like to use either a drop box, or some sort of check box. If a check box or option button is used, we could have it default to one value (22), then if the box is checked, change to the other.

the formula I am using in F12 which is the main one is =AVERAGE(F7:F8)*21/(4*(F10))+13.25

I'd like F10 to be selectable in some way. Currently a user has to enter a number manually, I'd like the drop box, or button to take care of that.

Is this possible?

Here is the file to look at CLICK HERE

I don't have any understanding of the form editing boxes, or vb.

Thank You



[ This Message was edited by: Coastie on 2002-05-26 11:13 ]

[Brian from Maui]

coastie,

How is the value in F10 derived?

[Coastie]

there are only 2 values F10 will ever be. It will either be 22 or 24.

It is derived from the rank structure in the Coast Guard. All personnel E4-E6 will use 22 and all E7-E9 will use 24. The page is used to figure a number used in calculating points for advancement.

If possible, I’d like it to default to 22, with a check box and something to the effect of

“E7 above check this box”

Once that box is checked F10 will switch from 22 to 24.

The numbers can be hidden from view

Also a simple drop down box would work. E4-E6 (would give 22 as the result) E7-E9 (would have 24 as the result)

Does that give you the information you asked?

[Brian from Maui]

coastie,

Have a look at this thread and Chris's enplanation

http://www.mrexcel.com/board/viewtop...9267&forum=2&6

Where they can select their grade and either 22 or 24 will appear depending on their grade

Or you could use an IF statement in F10

[ This Message was edited by: Brian from Maui on 2002-05-26 11:50 ]

[Coastie]

That does seem to be what i am after, but it all pretty confusing. I can't really figure out where/how to begin.

I read through the post, and tried some of it

now highlight the 3-celled range for CAR1
insert
name
define
names in workbook should be "CAR1"
refers to should be your highlighted range (with $$ signs to anchor it)
add
okay

but it is all still greek. I don't really understand what to do.

[mechpm]

am i being simple minded? could you not use data validation to create your list?


this works for me on similar work sheets in Excel 2002.

[Brian from Maui]

coastie,

In F10 enter this

=IF(a1<=e6,"22","24)

Where A1 houses your grade

I'm sure someone will come up with a better way.

[Coastie]

Thanks for that formula,

That gives me an error. I am using Excel 2000

It did suggest a corrected code and is using this

=IF(A1<=E6,"22","24")

the only difference I see are the capitol letters.

The code defaults to 22 and I can't seem to get it to change by altering the E* in block A1.

Any ideas?

[Brian from Maui]

coastie,

My apologies in the formula it's referring to the cell e6 etc instead of the grade, I was just testing it now, hang on I'll be right back

[Coastie]

On 2002-05-26 12:00, mechpm wrote:
am i being simple minded? could you not use data validation to create your list?


this works for me on similar work sheets in Excel 2002.

I'm really new at this. If it is more than simple addition/subtraction/multiplication or division it’s over my head at the moment.