Calculator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

It seems there should be a calculator function in Excel.
I'm often needing to add a few numbers together before
inserting them. Anyone know of such a thing?
 
There's no popup calculator built into Excel. People often just use a cell,
typing for example, =1+2+3 and Enter. If you don't want a formula in the
cell press F9 before the Enter.
 
It seems there should be a calculator function in Excel.
... Anyone know of such a thing?
Click to expand...

Of course, Windows 98 has one:
Start >> Programs >> Accessories >> Calculator

(But you probably knew that already.)
 
It seems there should be a calculator function in Excel.
I'm often needing to add a few numbers together before
inserting them. Anyone know of such a thing?
Click to expand...

Forgive me if you take offence, but I've found
your post quite amusing. Excel itself is a
calculator on super steroids.

If you want to add numbers just add them together
in the cell, as in...

=10.5+15+7+8.25

But you have to be a little careful when using multiple
operators. Excel doesn't always do math like you would
on a calculator. Use Help and look up... The order in
which Microsoft Excel performs operations in formulas.
You'll probably find it under Operators.

Jordon
 
Thank you once again. That will work perfectly for what I
was trying to do, and you're the only person who responded
without ridicule or sarcasm. I appreciate the tip.
 
Are you not aware of the right side of the status bar that gives you the
choice of displaying various calculations pertaining to selected cells.
You can simply select a group of cells and obtain either the sum, average,
count, or minimum or maximum of their contents.

Perhaps your display of this feature may be turned off.

In the area of the status bar, just to the left of where you can see
indicators of Num lock and/or scroll lock and/or caps, right click and you
will open a window which gives you a choice of the above mentioned
functions.

Just choose one ("None" might have been checked in your case), and then
select several cells containing numbers and see what is displayed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
I can pop up the win98 calculator pretty quickly by:
Windows Start button
Run
calc
ok

And if you do it lots, you may want to put an icon to the calculator on your
favorite toolbar.

Tools|customize|Commands tab
Tools Category
About 60% down (in xl2002's list), there's a Custom option with an icon that
looks like a calculator. (It's not the "Calculate Now" icon.) Drag it to your
favorite toolbar and try it out.

But I agree with the others.

I actually open a new workbook and type my numbers into different cells and then
hit the autosum button. I find fixing my typing mistakes easier when the values
are in their own cells.

(And sometimes I'll just enter the formula in the cell getting the sum. That
way I can know what I did.)
 
Thank you once again. That will work perfectly for what I
was trying to do, and you're the only person who responded
without ridicule or sarcasm.
Click to expand...

One wasted smiley then. Sorry man, no harm intended. I really do recognize the value of an
Excel calculator -just for the record.

Best wishes Harald
Followup to newsgroup only please.
 
Back
Top