Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 245
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,104
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Calculations Dina Excel Worksheet Functions 3 March 2nd 08 02:32 PM
how to do 2 calculations in 1 cell Joel Excel Discussion (Misc queries) 1 December 13th 07 09:41 AM
Formula for Cell Calculations Rick A Excel Discussion (Misc queries) 1 August 31st 07 08:10 AM
Calculations based on cell value Michael Wright Excel Worksheet Functions 2 November 3rd 06 02:15 PM
Cell Calculations Lilbit Excel Worksheet Functions 4 June 23rd 05 05:39 PM


All times are GMT +1. The time now is 09:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"