How...get a cell to offer options

R

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
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

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
 
Top