Operators in MS Excel

Operators in MS Excel

There are four different types of Operators in Excel: Arithmetic, Comparison, Text Concatenation and Reference.

Arithmetic Operators
To perform basic mathematical operations, such as addition, subtraction, multiplication, or division; combine numbers; and produce numeric results,use the following arithmetic operators.

Arithmetic Operator
Meaning
Operation Performed
Output
+ (plus sign)
Addition
3+3
6
- (minus sign)
Subtraction
3-1
2
-
Negation
-1
-1
* (asterisk)
Multiplication
3*3
9
/ (forward slash)
Divison
3/2
1.5
% (percent sign)
Percent
20%
.20
^ (caret)
Exponentiation
3^2
9


Comparison Operators
You can compare two values with the following operators. When two values are compared by using these operators, the result is a logical value -either TRUE or FALSE.

Comparison Operator
Meaning
Example
= (equal sign)
Equal to
A1=B1
> (greater than sign)
Greater than
A1>B1
< (less than sign)
Less than
A1<B1
>= (greater than or equal to sign)
Greater than or Equal to
A1>=B1
<= (greater than or equal to sign)
Less than or Equal to
A1<=B1
<> (not equal to sign)
Not Equal to
A1<>B1

Text Concatenation Operator
Use the ampersand (&) to concatenate (join) one or more text strings to produce a single piece of text.

Text Operator
Meaning
Example
& (ampersand)
Connects, or concatenates, two values to produce one continuous text value
"North" & "Wind"
results in "Northwind"
Reference Operators in MS Excel
Combine ranges of cells for calculations with the following operators.

Reference Operator
Meaning
Example
: (colon)
Range operator, which produces one
reference to all the cells between two
references, including the two
references.
B5:B15
, (comma)
Union operator, which combines
multiple references into one reference
SUM(B5:B15,D5:D15)
(space)
Intersection operator, which produces
one reference to cells common to the
two references
B7:D7 C6:C8

Note: AND,OR etc are logical functions not logical operators as they return value on passing arguments.


BACK TO CHAPTER 1

Around the MS Excel Sheet

Around MS Excel


Number
Contains
Description
1
Title Bar
Contains the name of the File that is currently open
2
Menu Bar
Contains various commands that can be performed by MS Excel
3
Tool Bar / Ribbon
Contains buttons for some commonly commanded tasks.
4
Formula Bar
Displays the content of an active cell. The left hand side of the bar is address of the active cell which is called Name Box
5
Column Label
Contains the heading of the columns. Represented by Letters.
6
Row Label
Contains the heading of the rows. Represented by Numbers.
7
Sheet Area
Enters and stores the actual data (i.e. text, date and numbers)
8
Sheet Tab
Gives Identities to sheet which is currently active. Contains the title/name of the sheet.
9
Status Bar
Gives a status update of the entire currently active sheet.


Introduction to MS Excel

Introduction to MS Excel

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows, Mac OS X, and IOS.

It features calculation, graphing tools, pivot tables, and macro programming language called VB for Application.

It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.


Microsoft Excel - The Basics

Microsoft Excel - Chapter 1


1. Introduction to MS Excel
2. Around the Excel Sheet
3. Operators in Excel
4. References in Excel
5. Sum, Average, Product, Power 
    (Introduction to Excel Math Functions)
6. Proper, Upper, Lower, Len, Trim
    (First Five Text Functions)
7. First 10 Excel Keyboard Shortcuts
8. Format Painter in Excel
9. Concatenate
10. Count, Counta, Countblank, Countif    
    (Counting Functions in Excel)