eHow launches Android app: Get the best of eHow on the go.
How to Download Files to Your Computer With an FTP Program
How to Create an Excel Formula
How to Create a Simple Budget in Excel
How to Copy Text From a PDF (Acrobat) Document
How to Create a Tent-Fold Greeting Card in a Word-Processing Program
How to Keep Track of Changes in an Excel Document
How to Create an Agenda Slide to Organize a PowerPoint Presentation
How to Merge Workbooks in Excel
How to Find Out if You Have a Network Card in Your PC & What Type it Is
How to Create a Formula in Excel 2003
How to Create a Simple Budget in Excel 2003
How to Find a Newsletter Template
How to Create a Simple Timeline With Excel
How to Free Up Memory Space on a Computer
How to Change Window Text in Windows XP
How to Change the Font Size in Hotmail Messages
How to Create a For Next Loop in Excel VBA
How to Create an Input Box in Excel VBA
How to Link Data to Another Spreadsheet in Excel
How to Download Videos From YouTube
How to Increase Internet Connection Speed
How to Make a Desktop Theme
Creating a Time Sheet
How to Find Out How Fast a Processor Is
How to Fix a Computer
How to Delete Everything on a Hard Drive
How to Change a Laptop Battery
How to Find Out What Type of Graphics Card is in a Computer
How to Make a Bar Graph Using Microsoft Excel 2003
How to Back Up Files to a Server
In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "S… More
Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on… More
Creating a formula in Excel 2003 is a great way to perform mathematical calculations and basic math using … More
Microsoft Excel is a powerful tool for analyzing data. The Forecast function provides users with a way of … More
Spreadsheet software offers very useful tools for both business and home applications where users are able… More
How to use Budget Formulas in this free series of personal finance video from our professional Certified P… More
There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in … More
VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to … More
After inserting data into Microsoft Excel, put the cursor into the desired cell and find the VARP function… More
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and sp… More
Microsoft Excel formulas can be used to take the sum or average of a set of data by typing an equal sign i… More
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound fun… More
Excel users can show formulas by clicking on a cell, which makes the formula appear in a text window. Lear… More
Summary: Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on data that's already been entered or through other cells within the workbook. Navigate Excel and write a formula to sum up a complex range of data on a PC using tips from a software developer in this free video on general computer tips.
Dave Andrews is a software developer with a business and Web site selling programs and other computer services in Franklin, Tenn. Having worked in the IT industry for more than 8...read more
"Hi, my name is Dave Andrews. Today I'm going to show you how to create an Excel formula. Let's open up Excel by clicking on the Start button. Let's go to "All Programs", "Microsoft Office" let's just open up Excel. Now a formula in Excel will do mathematical calculations either on data that you type in or on other cells within the workbook. To create a formula, click on the cell where you want your formula answer to appear, type the equals key to being the formula. Now you can put some kind of mathematical text in here, I'm just going to do something simple like 100 times 100 and I use the asterisk for times. There's my answer to that. I can do also 1 plus 1. There's my answer. Now if I want to do something a little more complex like summing up a range, let's just type some numbers here and we want to find what the sum of these are. I can easily tell just by highlighting them, Excel will tell me down here at the bottom the sum. But I want to put that in the cell here. And the way you do that, you say the equals, type the word "sum" and then create a parenthesis, an open parenthesis. Now after you type your open parenthesis, click on the first value with your mouse and highlight all the others by dragging down over them. Let off your mouse and then type a closed parenthesis. Now press the "enter" key and there's your answer to the sum. If I click in it, my formula's still up here at the top but its showing my answer here. This is dynamic which means that as these numbers change, so too does your sum. Its that easy to create a formula in Excel. My name is Dave Andrews and I've just told you how to create an Excel formula."
eHow Article: How to Create an Excel Formula
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
