Calculations within a cell
 

In a previous life I recall being able to click on a cell and up pops a
window in which I can do simple calculations, such as a list of items with
associated values. The window would automatically add the values and put the
result in as the cell value. I could later come back and 'diddle" the
entries within the pop up window. Well, no longer can recall how I did this.
HELP for an old guy. thanks
--
old guy

Calculations within a cell
 

You can perform calculations within a cell. Some examples:

=3+3 entered in a cell will display 6
=3*3 entered in a cell will display 9
=3^2 {3 squared} entered in a cell will display 9
= 27^(1/3) {cube root} entered in a cell will display 3

Use brackets as you would in a calculator.

HTH
--
Steve

"papa" wrote in message
...
In a previous life I recall being able to click on a cell and up pops a
window in which I can do simple calculations, such as a list of items with
associated values. The window would automatically add the values and put
the
result in as the cell value. I could later come back and 'diddle" the
entries within the pop up window. Well, no longer can recall how I did
this.
HELP for an old guy. thanks
--
old guy

Calculations within a cell
 

Have a look at Data | Data Validation
This gives the popup list and let's you select one item
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"papa" wrote in message
...
In a previous life I recall being able to click on a cell and up pops a
window in which I can do simple calculations, such as a list of items with
associated values. The window would automatically add the values and put
the
result in as the cell value. I could later come back and 'diddle" the
entries within the pop up window. Well, no longer can recall how I did
this.
HELP for an old guy. thanks
--
old guy