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.

BACK TO CHAPTER 1

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.

BACK TO CHAPTER 1

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)

BACK TO THE HOME PAGE