Calculations within a cell

[papa]

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

 

[AltaEgo]

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

 

[Bernard Liengme]

Have a look at Data | Data Validation
This gives the popup list and let's you select one item
best wishes