UsulArrakis
Mensajes publicados
7683
Estado
Colaborador
3 196
Differences between formulas There are also some important differences in how you create formulas in Excel: In Excel, you start a formula with an equals sign (=). It can also begin with a plus sign (+), just like in Lotus 1-2-3. Although it is not necessary, it is possible to type an at sign (@) in front of Excel functions. Excel uses two colons (:) to indicate a range of cells instead of the ellipsis (...) used by Lotus 1-2-3. Spreadsheet functions Some functions are evaluated differently Certain functions, including @MOD, @CONSV and @CONSH, are evaluated differently. For example, in Lotus 1-2-3, the @CONSV function looks for an exact match in the first column; in Excel, the worksheet CONSV function assumes that the first column is sorted and searches for the nearest value in that column without surpassing the value being sought. The worksheet functions CONSV and CONSH include, in Excel, a fourth argument, search_zone, which can be used to find an exact match. If you set this argument to FALSE, Excel will look for an exact match. Functions compatible with Excel 2000 and later contain functions to ensure compatibility with Lotus 1-2-3 version 4.0 and later. The functions beginning with “A” (AVERAGEA, MAXA, MINA, STDEVA, STDEVPA, VARA and VARPA) compute results using all cells in a range (including empty cells), cells containing text, and cells containing the logical values TRUE or FALSE.
