Expressions

Spreadsheet - Arithmetic expressions

Conditional expressions
Foglio elettronico - Le espressioni aritmetiche Folha de cálculo - As expressões aritméticas Kalkulationsprogramm - die arithmetischen Begriffe Tableur - Les expressions arithmétiques

Introduction

Arithmetic expressions are simple expressions built with arithmetic operators and constants or references to cells. Operands are the values upon which the operator acts. There are two types of arithmetic operators:

  • Unary operators that act upon just one element; using only one operand located on the right of the operator. For example: 
    =-A6
  • Binary operators that act upon two elements (using two operands, one located on either side of the operator). For example: 
    =B4 + A6

Arithmetic Operators

Arithmetic operators are as follows:

Operator Name Type Description
+ Addition Operator Binary Adds two values
- Subtraction operator Binary Subtracts two values
- Inversion Operator Unary Gives the opposite value of a value
* Multiplication operator Binary Multiplies two values
/ Division operator Binary Divides two values
^ Power operator Binary Multiplies the left operand to the specified power shown by the right operand
% Modulo operator Binary Gives the remainder of the whole division of two numbers

Use of Parenthesis

Arithmetic operators are used in a predefined order or priority. To modify the predefined priority, parenthesis must be used. Here is a table that shows the priority of the operators:

Operator Priority
++++++ ()  
+++++ %  
++++ ^  
+++ -  
++ * /
+ + -

When two operators have the same priority, the calculation is performed from left to right.



Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheet - Arithmetic expressions » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Best answers for « Spreadsheet Arithmetic expressions » in :
Spreadsheet - Expressions Show The Concept of an Expression Expressions allow the spreadsheets to perform simple calculations using values from many cells. There are generally many types of expressions: Arithmetic expressions Conditional expressions Text expressions
Spreadsheets - Conditional expressions Show What is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Spreadsheets - Arithmetic Functions Show The Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Converting a URL to a clickable hyperlink ShowConverting a URL to a clickable hyperlink With regular expressions, it is possible to transform any hyperlink URL of the form http://URL (or ftp://URL) or beginning with www. :
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
[Sed] Delete one or more lines from a file Show[Sed] Delete one or more lines from a file Removing one (or several) line (s) of a file Syntax: sed '{[/]||[/]}d' sed '{[/][,][/]d' /.../=delimiters n = line number...
Download Spreadsheet Converter ShowIt is not always necessary to create a complex script in order to insert a form into a web page. The use of some line of Javascript of Spreadsheet Converter allows you to use online form. Spreadsheet Converter is a program to create a form for a...
Download Excel Viewer Show
Download OpenOffice ShowOpenOffice is a free office application suite, including a word processor, spreadsheet, presentation tool, drawing package and database, compatible with all other major office suites like Microsoft Office (97-2007 formats). Writer Calc ...
Spreadsheet - Functions ShowThe Concept of a Function Spreadsheets generally have a large number of integrated functions for processing data. There are hundreds, categorised as follows: Arithmetic functions that offer basic tools to process numerical data Statistical...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
They need your help