Share in Facebook


30 May 2017

Operators in Excel Uses of Operators in MS Excel

Today I would like to highlight some points about OPERATOR.
Operators specify the type of calculation that you want to perform on the elements of a formula, like addition, subtraction, multiplication or division. There is a default order in which calculations occur, but you can change this order by using parentheses.

Arithmetic operators


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


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.



Operator precedence

If you combine several operators in a single formula, Excel performs the operations in the order shown in the following table. If a formula contains operators with the same precedence — for example, if a formula contains both a multiplication and division operator — Excel evaluates the operators from left to right.
In a simpler language “How a formula decides which operator’s job to be processed first”.



29 May 2017

SUMIF Function Quick Steps

This Excel tutorial explains how to use the Excel SUMIF function step-by-step with syntax and examples, works very fast.
Description
The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000).
The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet.
Syntax






The syntax for the SUMIF function in Microsoft Excel is:
SUMIF( range, criteria, [sum_range] )
Parameters or Arguments
range
The range of cells that you want to apply the criteria against.
criteria
The criteria used to determine which cells to add.
sum_range
Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range
Example (as Worksheet Function)
Let's explore how to use SUMIF as a worksheet function in Microsoft Excel.


How to use : 




  1.  Put '=' sign before entering the fomula.
  2. Type "SUMIF", press tab to get ( sign or alternatively you can type it.
  3. Select the total range (in above picture B & C Column)
  4. Put a comma and type / select for what you want to calculate the sum.
  5. Put a comma and select the range ((in above picture "C" Column)
  6. And you are done.
For any question please comment.

28 May 2017

SUM Function and Various Methods

Welcome to the Microsoft Excel.


This Excel tutorial explains how to use the Excel SUM function step-by-step with syntax and examples.



Description
The Microsoft Excel SUM function adds all numbers in a range of cells and returns the result.
The SUM function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUM function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the SUM function in Microsoft Excel is:
SUM( number1, [number2, ... number_n] )
OR
SUM ( cell1:cell2, [cell3:cell4], ... )
Parameters or Arguments
number
A numeric value that you wish to sum.
cell
The range of cells that you wish to sum.
Note
  • You can sum combinations of both numbers and ranges of cells using the SUM function.
Applies To
  • Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
  • Worksheet function (WS)
Example : You can also press Alt and '+' sign to get SUM using shortcuts.