Skip to main content

DIFFERENT OPERATORS IN MS-EXCEL

                                    OPERATORS 




Operators are used in formulas to execute operations on the values taken by formulas. 

Excel use 4 types of operators :

1.Arithmetic Operators


2.Text Concatenation Operators 


3.Comparison Operators 


4.Reference Operators 


Arithmetic Operators

This operation will explained through example

Example 


Text Concatenation Operators 


This operation will explained through example

Example 


Comparison Operators 

To compare values you can create formulas using comparison operators. These operators return a TRUE or FALSE result depending how the formula evaluate the condition .Some common operator are as follow:




Reference Operators 

Reference operators enable you to combine absolute and relative references and named ranges. Reference operators are valuable for joining cells or referring to a common area shared shared between different  ranges. 

COLON


COMMA


SPACE                    









Labels:
Location: West End Mall, Janakpuri West, Janakpuri District Center, Janakpuri, Delhi, 110058, India

Comments

Post a Comment

Popular posts from this blog

TYPE OF LANGUAGE & TRANSLATORS of the Computer

                                                                            LANGUAGES OF THE COMPUTER Languages of the Computer All we known about computer that it is a electronic device. It do it task after instruction are given to it by the user. But we should also known about it's language too. Computer is a machine oriented. It understand only programming language & machine language or we can say binary language. Web Designing Courses What is Binary Language ???? Binary is a way to show any type of data (such as number and text ). Computer work only in binary language. Binary is a number system and is known as a base 2 system because it uses two characters- 0 & 1   Basic Types of Programming & Computer Languages are : 1.Low - Level Language a) M...
Post a Comment
Read more

FORMULA MS-EXCEL PART-4

                                DATE & TIME  FUNCTION   1. TODAY ( ) :- Summary  The Excel TODAY function returns the current date, updated continuously when a worksheet is changed or opened. The TODAY function takes no arguments. You can format the value returned by TODAY using any standard date format. If you need current date and time, use the  NOW function . Purpose  Get the current date Return value  Valid Excel date Syntax  =TODAY () Arguments  Usage notes  The TODAY function takes no arguments, and returns the current date, updated whenever a worksheet is changed or opened. You can also use F9 to force the worksheet to recalculate and update the value. If you need a static date that won't change, you can  enter the current date using the keyboard shortcut  Ctrl +...
Post a Comment
Read more

TYPES OF COMPUTERS......

Hello Readers, This blog is about "Types of Computer". It is very necessary to understand types of computer, to understand them separately. Computers are classified according to their Sizes , Functionality and Data Handling . 1.  According to  functionality  computers  are classified as : Types of Computer (Functionality)                               ( EBEES INFOTRAIN CONSULTANCY SERVICES PVT. LTD.  ) . a. Analog Computers  An analog computer (spelt analogue in British English) is a form of computer that uses  continuous  physical phenomena such as electrical, mechanical, or hydraulic quantities to model the problem being solved. Example ( thermometer, blood pressure machine)  b. Digital Computers A computer that performs calculations and logical operations with quantities represented as digits, usually in the  binary numbe...
Post a Comment
Read more