Scribd
Upload
16 views3 pages

Excel Formulas and Functions

The document provides a comprehensive list of Excel formulas and functions categorized into mathematical, statistical, and logical functions. Each function is accompanied by a brief definition and an example of its usage. This serves as a reference guide for users looking to utilize Excel's capabilities effectively.

Uploaded by

vipin8383950536
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
16 views3 pages

Excel Formulas and Functions

The document provides a comprehensive list of Excel formulas and functions categorized into mathematical, statistical, and logical functions. Each function is accompanied by a brief definition and an example of its usage. This serves as a reference guide for users looking to utilize Excel's capabilities effectively.

Uploaded by

vipin8383950536
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

All Excel Formulas and Functions with Definitions

Mathematical Functions

SUM() - Adds a range of numbers. Example: =SUM(A1:A5)

SUBTOTAL() - Performs summary functions. Example: =SUBTOTAL(9, A1:A10)

PRODUCT() - Multiplies numbers. Example: =PRODUCT(A1:A3)

ROUND() - Rounds a number. Example: =ROUND(12.3456, 2)

ROUNDUP() - Rounds up. Example: =ROUNDUP(12.3, 0)

ROUNDDOWN() - Rounds down. Example: =ROUNDDOWN(12.9, 0)

CEILING() - Rounds up to nearest multiple. Example: =CEILING(4.2, 1)

FLOOR() - Rounds down to nearest multiple. Example: =FLOOR(4.8, 1)

ABS() - Returns absolute value. Example: =ABS(-10)

MOD() - Returns remainder. Example: =MOD(10, 3)

POWER() - Raises to a power. Example: =POWER(2, 3)

SQRT() - Square root. Example: =SQRT(16)

Statistical Functions

AVERAGE() - Mean value. Example: =AVERAGE(A1:A5)

MEDIAN() - Middle value. Example: =MEDIAN(A1:A5)

[Link]() - Most frequent value. Example: =[Link](A1:A5)


All Excel Formulas and Functions with Definitions

MAX() - Highest number. Example: =MAX(A1:A5)

MIN() - Lowest number. Example: =MIN(A1:A5)

COUNT() - Counts numbers. Example: =COUNT(A1:A10)

COUNTA() - Counts non-empty cells. Example: =COUNTA(A1:A10)

COUNTIF() - Counts if condition met. Example: =COUNTIF(A1:A10, '>50')

COUNTIFS() - Counts with multiple conditions. Example: =COUNTIFS(A1:A10, '>50', B1:B10, '<100')

RANK() - Returns rank. Example: =RANK(A1, A1:A10)

LARGE() - Nth largest number. Example: =LARGE(A1:A10, 2)

SMALL() - Nth smallest number. Example: =SMALL(A1:A10, 2)

Logical Functions

IF() - Returns value if condition met. Example: =IF(A1>50, 'Pass', 'Fail')

IFS() - Multiple IF conditions. Example: =IFS(A1>90, 'A', A1>75, 'B')

AND() - All conditions true. Example: =AND(A1>10, B1<5)

OR() - Any condition true. Example: =OR(A1>10, B1<5)

NOT() - Reverses logic. Example: =NOT(A1>10)

IFERROR() - Handles errors. Example: =IFERROR(A1/B1, 'Error')


All Excel Formulas and Functions with Definitions

IFNA() - Handles #N/A errors. Example: =IFNA(VLOOKUP(...), 'Not Found')

You might also like