Entering arithmetic operations

J

Joseph N.

Hello. I'm a 1-2-3 user who is trying to become familiar with Excel. I
have a very basic question, and would appreciate any help from
experienced users.

In 1-2-3, if one opens a sheet and enters "4*5" the cell will show "20".
Entering "10/2" will yield "5". But in Excel, even if the cells are
specifically formatted as Number, it seems to be necessary to put "=" in
front, so that one has to enter "=4*5" or "=10/2". Since the equal sign
is in only one place and not on the extended numeric keyboard, I have to
think that there's another way to do this.

So, the question is whether it is really necessary to add "=" before an
arithmetic operation, or is there an alternative?

jbn10161 at fastmail dot fm
 
P

Paul B

Joseph, you can use the + sign, excel will turn it into an = sign in the
formula

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
P

Paul B

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top