ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Calculating inside a cell? (https://www.excelbanter.com/excel-worksheet-functions/199594-calculating-inside-cell.html)

JW

Calculating inside a cell?
 
Is it possible to add 5+5+5 in one cell and hit enter? Just trying to avoid
using a calculator.
--
JW

Gary''s Student

Calculating inside a cell?
 
Start with =


=5+5+5

Excel makes a fine calculator!
--
Gary''s Student - gsnu200801


"JW" wrote:

Is it possible to add 5+5+5 in one cell and hit enter? Just trying to avoid
using a calculator.
--
JW


Peo Sjoblom[_2_]

Calculating inside a cell?
 
Toolsoptionstransition and select transition formula entry, now try to
enter the same numbers again

Note that it has some drawbacks like you can't enter dates and probably some
more

--


Regards,


Peo Sjoblom

"JW" wrote in message
...
Is it possible to add 5+5+5 in one cell and hit enter? Just trying to
avoid
using a calculator.
--
JW




Spiky

Calculating inside a cell?
 
On Aug 20, 2:01 pm, Gary''s Student
wrote:
Start with =

=5+5+5

Excel makes a fine calculator!



Or start with another +, conveniently located under your pinky finger.
Since somehow the world settled on the stupid keyboards without the =
on the keypad in the early 90s.


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com