1. Home
  2. Computing & Technology
  3. Spreadsheets

Formula

By , About.com Guide

Cell formulas in Excel spreadsheets

Cell formulas in Excel spreadsheets

© Ted French
Definition: A formula in a spreadsheet, such as Excel, is a mathematical equation used to caluculate a value. In Excel formulas must begin with an equal ( = ) sign.

In Lotus 1-2-3 and Quattro Pro, formulas begin with a plus ( + ) sign.

Alternate Spellings: formulae
Examples: Entering the following formula into cell B6
=(B4*B5)*5
will calculate the total cost of the items.



Related Articles

Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Definitions
  5. F
  6. Excel Formulas Definition - Spreadsheets Terms - Excel Definition

©2009 About.com, a part of The New York Times Company.

All rights reserved.