Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
Doing Simple Arithmetic In Excel.
Posted by - NA - on 30 March 2006 07:47 AM
|
|
Solution: When you want to simply add, subtract, or divide a few numbers in Excel, you can just type in an equal sign followed by the numbers. For example, if you want to add 96 and 23, you'd type =96+23 and press Enter. This is certainly simple enough, but if you'd rather not have to remember to type in that equal sign first, you can get Excel to drop the requirement. Just open a blank worksheet and choose Tools/Options. When the Options dialog box opens click the Transition tab. Select the check box labeled "Transition formula entry" and click OK. Now, you can simply enter 96 + 23 to get the result of 119. Note that you will now have to enter an apostrophe before a number that you want to enter as text. | |
|
Comments (0)