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

WHAT IS A COMPUTER? Hardware & Software

In this blog we will discuss about ,"What is computer and differences among its part as Hardware & Software". We know that all information are scattered in google but I want to make it easy for our readers.Otherwise it is difficult to know which information is right and which is wrong . My Blog is dedicated to learners & easy learning  WHAT IS A COMPUTER? What is Computer  : Computer is an electronic device that is designed to work with Information. The term computer is derived from the Latin term  ‘compute’ , this means to  calculate  or  programmable machine .   Therefore computers can perform complex and repetitive procedures quickly, precisely and reliably. Modern computers are electronic and digital. All general-purpose computers require the following hardware components: §   Central processing unit (CPU) : The heart of the computer, this is the component that actually executes instruction...
2 comments
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

BRIEF OF EXCEL FORMULAS (PART-1)

EBEES INFOTRAIN CONSULTANCY SERVICES PVT. LTD. 1. SUM :  Summary  The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. Purpose  Add numbers together Return value The sum of values supplied. Syntax  =SUM (number1, [number2], [number3], ...) Examples In the example shown, the formula in D12 is: = SUM ( D6:D10 ) // returns 9.05 2.Round() :  Summary  The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point. Purpose  Round a number to a given number of digits Return value  A rounded number. Syntax  =ROUND (number, num_digits) Arguments  number  - The number to round. num_digits  ...
Post a Comment
Read more