MS Excel Formulas List PDF

Hello friends, in today’s article, I am going to share with you Microsoft Excel’s Basic & Advanced Formulas List PDF which you can download from the link given below.

Microsoft Excel Basic + Advanced Formula List PDF Download

Different types of sheets are prepared in Microsoft Excel. There are many types of calculations. Formulas are needed to perform these calculations. Just as formulas are needed to solve any problem in mathematics, similarly formulas are also needed to work in MS Excel. After which your calculation becomes even easier.

MS Excel Basic Rules

  • Whenever you write a formula, always start it with the sign of =.
  • Be sure to use brackets in the formulas where necessary.
  • Use * for multiplication, / for divide, + for addition, and – for subtraction.
  • be careful while writing formulas.
  • Use the mouse to select the value.
  • After completing the formula, press enter at the end.
  • If any kind of error is showing, then check the formula again.
  • avoid spelling mistakes. 

Examples

If you want to sum two or more numbers in ms excel, then for this you have to write =SUM(number1,number2,…). As soon as you write this formula, you will get the answer.

If you have many numbers, in which you have to write Maximum Value, then for this you have to make =MAX(Cell Range) Formula, after that press enter, and you will get the maximum value.

Apart from these formulas, Date and Time, Financial, Logical, Mathematical, and Statistical formulas are also used.

See also  Jhansi Ki Rani Story in Hindi

For example, if you are preparing the student’s marksheet, then you have to pass or show it in the result. For which you use conditional statements =IF(statement).

Excel SUM formula:=SUM (C2,C3,C4,C5)
Excel Average Formula: =Average (C2,C3,C4,C5)
SumIF formula =SUMIF (A2:A7,“Items wanted”, D2:D7)
COUNTIF Formula: =COUNTIF(D2:D7, “Function”)
Concatenate Function: =CONCATENATE(C4,Text, D4, Text,…)
Int Formula: =int (this number)
MAX Formula: =Max(D2:D7)
Factorial Formula =FACT(number)
VLookup Formula = Vlookup(value, range, and get me value in the column, is my list sorted)
IF function formula: =IF(E2>2000, correct/Incorrect)

To download Full PDF of Excel Basic & Advanced Formula List, click on the link given below.

Download Now

Leave a Comment