CALCULATIONS IN MICROSOFT EXCEL


Calculation is the process of computing formulas and then displaying the result as values in the cells that contain the formulas.

 

It is very easy to perform Arithmetic & Logical operations or calculations in Microsoft Excel. In Microsoft Excel, figures are not referenced but the cell. It is wrong to calculate the value you have in a cell by referring to that value. You can only refer to the cell where you have the value. For you to know refer to a Cell, you must first of all call it by the column follow by the row e.g A1, B6, H7, C4, etc.

 

OPERATORS

Operators are the symbols or signs used for calculations in Microsoft Excel. Below are some operators that can be used in MS-EXCEL.

 

COMMON OPERATORS

^

-

+

/

%

*

>

<

>=

<=

=

< >

:

,

 

There are two methods of calculation in Microsoft Excel. These are:

1.            FORMULA METHOD          

2.            FUNCTIONS METHODe.g

 



Related Posts:

  • CALCULATIONS IN MICROSOFT EXCEL Calculation is the process of computing formulas and then displaying the result as values in the cells that contain the formulas.   It is ver… Read More
  • USING FUNCTION METHOD OF CALCULATION Functions in Excel are the in-built method of calculation, which can be invoked anytime the user wants to make use of it. e.g SUM for addition, MAX … Read More
  • VLOOKUP Examples And Videos How to use a VLOOKUP formula to get data from an Excel list. Troubleshoot VLOOKUP when things go wrong. Step-by-step videos and free workbooks with … Read More
  • Excel MIN and MAX Functions Find the lowest and highest values with the MIN and MAX functions. Use with the IF function, to create MIN IF and MAX IF formulas. MIN Function To… Read More
  • Excel INDIRECT Function The INDIRECT function returns a reference to a range. You can use this function to create a reference that won't change if row or columns are insert… Read More