Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Calculations | Excel Worksheet Functions | |||
how to do 2 calculations in 1 cell | Excel Discussion (Misc queries) | |||
Formula for Cell Calculations | Excel Discussion (Misc queries) | |||
Calculations based on cell value | Excel Worksheet Functions | |||
Cell Calculations | Excel Worksheet Functions |