LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
CEN7272 - ExcelForums.com
 
Posts: n/a
Default substitute for =

First off, It's always bugged me that there is no equal sign on the
number pad of my keyboard, it just seems like it's something that
should be included in that set of keys.

The other day I found that you can use + or - instead of
= to perform simple calculations. For instance if you
wanted to find the solution to 15*30 you could type +15*30 instead of
=15*30. The same is true with -, so if you type -2+4 you get 2.
Also if you type - instead of = for more complex functions, Excel
automatically adds that equal sign and negates the answer.

*This may not seem like a big deal and I'm not sure if anyone else has
ever posted it (I didn't come up with any search results) but since I
stumbled across it a couple days ago I've found it pretty
useful/interesting so I just wanted to pass it along.

 
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
Substitute for Pivot tables? DerbyJim1978 Excel Worksheet Functions 0 July 12th 05 05:31 PM
substitute AMK Excel Worksheet Functions 1 June 13th 05 01:23 AM
Is there a VLOOKUP substitute when data is not in ascending order VJ7777 Excel Worksheet Functions 2 January 19th 05 08:32 AM


All times are GMT +1. The time now is 01:41 PM.

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"