Excel Formulas

In this article you will see the formulas which we use in excel for mathematical purposes.The following are the most commonly used formula in excel.

=Sum(values)
For Addition of values.
=(value1-value2)
For subtraction of values.
=(value1*value2)
For multiplication of values.
=(value1/value2)
For devision of values.
=count(select all cells)
For counting all cells
=countblank(select all cells)
For counting blank cells
=countif(select values,"condition")
For specific condtion counting
=if(condition,"Display text")
For grades in result specially used formula.

Share on Google Plus

About Rabia Tufail

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.