Scribd
Upload
92 views2 pages

Excel Formulas Complete Guide

The document is a comprehensive guide to Excel formulas, categorized into basic, logical, and text formulas. Each formula is presented with its purpose and an example for clarity. It covers essential functions like SUM, AVERAGE, IF, CONCAT, and more.

Uploaded by

Tonmoy Monndol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
92 views2 pages

Excel Formulas Complete Guide

The document is a comprehensive guide to Excel formulas, categorized into basic, logical, and text formulas. Each formula is presented with its purpose and an example for clarity. It covers essential functions like SUM, AVERAGE, IF, CONCAT, and more.

Uploaded by

Tonmoy Monndol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

■ Excel Formulas – Complete Guide

■ BASIC FORMULAS
Function Purpose Example

=SUM(A1:A5) Adds numbers Total of A1 to A5

=AVERAGE(A1:A5) Average of numbers Mean of values

=MIN(A1:A5) Minimum value Lowest number

=MAX(A1:A5) Maximum value Highest number

=COUNT(A1:A5) Count of numbers How many numbers

=COUNTA(A1:A5) Count non-blank cells Includes text

=ROUND(A1, 2) Round to decimal 2 decimal places

=INT(A1) Rounding down Integer only

=MOD(A1, B1) Remainder Modulo operator

=ABS(A1) Absolute value No sign

■ LOGICAL FORMULAS
Function Purpose Example

=IF(A1>10, "Yes", "No") Condition Returns Yes or No

=AND(A1>10, B1<5) True if both true Logical AND

=OR(A1>10, B1<5) True if either true Logical OR

=NOT(A1>10) Opposite Logical NOT

=IFERROR(A1/B1, "Error") Catch error Avoids #DIV/0!

■ TEXT FORMULAS
Function Purpose Example

=CONCAT(A1, B1) Join text Combines cells

=TEXT(A1, "dd-mm-yyyy") Format Convert number/date

=UPPER(A1) Uppercase ABC

=LOWER(A1) Lowercase abc

=PROPER(A1) Title Case Abc Def

=LEN(A1) Text length Count characters

=LEFT(A1, 4) First characters First 4 chars

=RIGHT(A1, 4) Last characters Last 4 chars

=MID(A1, 2, 3) Middle From 2nd, 3 chars


Function Purpose Example

=TRIM(A1) Remove spaces Extra space removed

=SUBSTITUTE(A1, "old", "new") Replace text Word swap

You might also like