Calculations within a cell

  • Thread starter Thread starter papa
  • Start date Start date
P

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
 
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
 
Have a look at Data | Data Validation
This gives the popup list and let's you select one item
best wishes
 
Back
Top