Calculation operators in formulas

¡Supera tus tareas y exámenes ahora con Quizwiz!

+

addition (arithmetic)

reference operators

combine ranges of cells for calculations

&

connects, or concatenates two values to produce one continuous value

/

division (arithmetic)

=

equal to (comparison)

^

exponentiation (arithmetic)

>

greater than (comparison)

>=

greater than or equal to (comparison)

<

less than (comparison)

<=

less than or equal to (comparison)

*

multiplication (arithmetic)

<>

not equal to (comparison)

%

percent (arithmetic)

:

range operator, produces one reference to all the cells between two references (reference)

-

subtraction/negation (arithmetic)

comparison operators

to compare two values; the result is a logical value; either TRUE or FALSE

arithmetic operator

to perform basic mathematical operations such as addition, subtraction or multiplication; to combine numbers

,

union operator, combines multiple references into one reference (reference)

text concatenation operator

use the ampersand (&) to join, or concatenate one or more text strings to produce a single piece of text


Conjuntos de estudio relacionados

Macroeconomics Chapters - 4, 5, 7

View Set

Classification Study Guide-Science

View Set

Money and Banking Chapter 15, Money & Banking Chapter 7, M&B Chapter 17, M&B Chapter 16, Money and Banking Chapter 10, Money and Banking Chapter 12, Money and Banking Chapter 14

View Set

Az első felelős és független magyar kormány tagjai

View Set

Ethics ACNT 1370 Final All Chapters MC

View Set