arithmetic+operators

3.2.4 b
 * ===understand arithmetic operators including operators for integer division (+, -, *, /, MOD and DIV) and use these to construct expressions;===

=**Arithmatic operators**= = **KeyWords:** = = **Arithmetic** =

The mathematics of integers, rational numbers, real numbers, or complex numbers under addition, subtraction, multiplication, and division.
= Integral =

Necessary to make complete essential or fundamental "integral sections".
=** Modulus arithmetic **=

a system of arithmetic for integers, where numbers "wrap around" after they reach a certain value
= =

= =

An arithmetic operator is the symbol or sign that represents a mathematical operation in an Excel spreadsheet formula
=**Arithmetic operations resolve calculations of numeric values represented by literals, variables, other expressions, function and property calls, and constants.**= =E.G of calculations= = = =__adding two values__= =Dim x As Integer= =**x**= =**67 + 34=**= =**__Subtracting two values__**= =**x**= =**32 - 12==**= =**__Multiplication and division use the__** *** and** / **operators, as in this example:**= =You can add two values in an expression together with the **+** operator, or subtract one from another with the **-** operator, as shown in the following example=

=Dim y As Double= =y=45 * 55.23==

=y=32 / 23==

=__Modulus arithmetic is performed using the **Mod** operator.__= = = =This operator returns the remainder after the divisor is divided into the dividend a correct number of times. If both divisor and dividend are necessary types, the returned value is correct. If divisor and dividend are floating point types, the returned value is a floating point variable. Two examples illustrate this:= = = =x As integer= =100== =y As Integer= =6== =z As Integer= =z= =x Mod y ' z equals 4.== =a As Double= =100.3== =b As Double= =4.13== =c As Double= =c= =a Mod b ' c equals 1.18.== =right division is carried out using the **\** operator. Integer division returns the number of times one integer can evenly divide into another. Only integral types (**Byte**, **Short**, **Integer**, and **Long**) can be used with this operator. All other types must be converted to an integral type first. The following is an example of integer division:=

=Dim k As Integer= =k== =**23 \ 5 ' k = 4==**=

=** Exam questions **=