Excel Formulas List Pdf

Excel Formulas List Pdf

Excel Formulas List Pdf, All Excel Formulas with Examples. Advanced Excel Formulas PDF.

PDF NameExcel Formulas List Pdf
No. of Pages2
PDF Size483 kb
LanguageEnglish
PDF CategoryEducation & Jobs
Download LinkAvailable
Published/UpdatedFebruary 10, 2023
Source / Creditsmypdf
Uploaded ByMyPdf

Excel Formulas List Pdf

SUMAdds up a range of cells
AVERAGECalculates the average of a range of cells
COUNTCounts the number of cells in a range that contain numbers
MAXReturns the maximum value in a range of cells
MINReturns the minimum value in a range of cells
IFPerforms a logical test and returns one value if the test is true, and another value if it’s false
VLOOKUPSearches for a value in the first column of a table, and returns a corresponding value in the same row from another column
HLOOKUPSearches for a value in the first row of a table, and returns a corresponding value in the same column from another row
INDEXReturns the value of a cell in a specified row and column of a range
MATCHSearches for a value in a range and returns the relative position of the value within the range
CONCATENATEJoins two or more text strings into one string
LEFTReturns a specified number of characters from the start of a text string
RIGHTReturns a specified number of characters from the end of a text string
MIDReturns a specified number of characters from a text string, starting from a specified position
LENReturns the length of a text string (the number of characters)
DATEReturns the current date
TIMEReturns the current time
NOWReturns the current date and time
DAYReturns the day of the month for a given date
MONTHReturns the month for a given date
YEARReturns the year for a given date
ROUNDRounds a number to a specified number of decimal places
ROUNDUPRounds a number up to a specified number of decimal places
ROUNDDOWNRounds a number down to a specified number of decimal places
FLOORRounds a number down to the nearest integer
CEILINGRounds a number up to the nearest integer
ABSReturns the absolute value of a number (removes the sign)
MODReturns the remainder of a division operation
SQRTReturns the square root of a number
EXPReturns the result of raising a number to a power
LNReturns the natural logarithm of a number
LOG10Returns the base-10 logarithm of a number
PIReturns the value of Pi
SINReturns the sine of an angle
COSReturns the cosine of an angle
TANReturns the tangent of an angle
ASINReturns the arcsine of a number
ACOSReturns the arccosine of a number
ATANReturns the arctangent of a number
ANDReturns TRUE if all arguments are TRUE, and FALSE otherwise
ORReturns TRUE if any argument is TRUE, and FALSE otherwise
NOTReverses the logic of an argument (returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE)

Excel Formulas with Examples

Excel has a vast range of formulas that can perform various calculations and manipulations of data. Here is a list of some of the most commonly used Excel formulas, along with examples:

  1. SUM: This formula adds up a range of cells. Example: =SUM(A1:A5)
  2. AVERAGE: This formula calculates the average of a range of cells. Example: =AVERAGE(A1:A5)
  3. COUNT: This formula counts the number of cells in a range that contain numbers. Example: =COUNT(A1:A5)
  4. MAX: This formula returns the highest value in a range of cells. Example: =MAX(A1:A5)
  5. MIN: This formula returns the lowest value in a range of cells. Example: =MIN(A1:A5)
  6. IF: This formula returns one value if a condition is true and another value if it’s false. Example: =IF(A1>10, “Greater than 10”, “Less than or equal to 10”)
  7. VLOOKUP: This formula searches for a value in the first column of a table and returns a value in the same row from a specified column. Example: =VLOOKUP(A1, A2:B5, 2, TRUE)
  8. HLOOKUP: This formula searches for a value in the first row of a table and returns a value in the same column from a specified row. Example: =HLOOKUP(A1, A2:B5, 2, TRUE)
  9. INDEX/MATCH: This formula returns the value of a cell in a specified row and column of a table. Example: =INDEX(A2:B5, MATCH(A1, A2:A5, 0), 2)
  10. CONCATENATE: This formula combines text from multiple cells into one cell. Example: =CONCATENATE(A1, ” “, A2)

This is just a brief overview of some of the most common Excel formulas. There are many more formulas available in Excel that can perform various functions, including statistical analysis, text manipulation, and financial calculations.

So, don’t delay and download the PDF from the link given below.


You can download the Excel Formulas List Pdf the link given below:


Report This: We DO NOT own any copyrights of this PDF File. If you want this All Country Code Number List Pdf to be removed or if it is copyright infringement, do drop us an email at [email protected] and this will be taken down within 24 hours!