How...get a cell to offer options

[ram1000]

How do I get a cell to offer options in Excel 97. For example I want t
be able to chose by clicking on the cell between these options:

$92.40
$67.30


Thank yo

 

[Norman Harker]

Hi Ram1000!

You can use:

Data > Validation > List
Type in your options with the separator used in functions (comma or
continental Europe is

Or probably better, use an IF function if you can determine the
criteria for determining the option.

Example:
=IF(A1<1000,92.4,67.3)

In both cases it is better to use cell references than to hard code
the amounts.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Gord Dibben]

ram

Data>Validation>Allow>List. Show Drop-down arrows.

Either type in your options separated by commas or have them on your worksheet
and point to them.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
have a look at 'data - Validation'. Also see
http://www.contextures.com/xlDataVal01.html