Functions In EXCEL


All that functions that used in Excel & useful in many industries. They Are as follows...

Here are the excel functions. Hope this will help you out to know the uses while working with Excel file.

EXCEL Functions List































































































































































funtionused asworks as
Age Calculation SampleUsing DATEDIF()
AutoSum shortcut keySampleUsing Alt and =500 MB HD
Brackets in formulaSampleSample
FileName formulaSampleUsing MID() CELL() and FIND()
Instant ChartsSampleUsing F11
Ordering StockSampleStock Ordering
PercentagesSampleHow to calculate various percentages
Project DatesSampleExample using date calculation.
Show all formulaSampleUsing Ctrl and`
Split ForenameSurnameSample Using LEFT() RIGHT() FIND() SUBSTITUTE()
Time CalculationSampleHow to calculate time.
TimeSheet For FlexiSampleExample flexi time sheet.
ABSMathematicalReturns the absolute value of a number
ANDLogicalReturns TRUE if all its arguments are TRUE
AVERAGEStatisticalReturns the average of its arguments
BIN2DECEngineeringConverts a binary number to decimal
CEILINGMathematicalRounds a number to the nearest integer or to the nearest multiple of significance
CELLInformationReturns information about the formatting, location, or contents of a cell
CHARTextReturns the character specified by the code number
CHOOSELookupChooses a value from a list of values
CLEANTextRemoves all nonprintable characters from text
CODETextReturns a numeric code for the first character in a text string
COMBINMathematicalReturns the number of combinations for a given number of objects
CONCATENATETextjoins several text items into one text item
CONVERTEngineeringConverts a number from one measurement system to another
CORRELStatisticalReturns the correlation coefficient between two data sets
COUNTStatisticalCounts how many numbers are in the list of arguments
COUNTAStatisticalCounts how many values are in the list of arguments
COUNTBLANKInformationCounts the number of blank cells within a range
COUNTIFMathematicalCounts the number of nonblank cells within a range that meet the given criteria
DATEDateReturns the serial number of a particular date
DATEDIFDateCalculates the difference between two dates. Undocumented in v5/7/97
DATEVALUEDateConverts a date in the form of text to a serial number
DAVERAGEDatabaseReturns the average of selected database entries
DAYDateConverts a serial number to a day of the month
DAYS360DateCalculates the number of days between two dates based on a 360-day year
DBFinancialReturns the depreciation of an asset for a specified period using the fixed-declining balance method
DCOUNTDatabaseCounts the cells that contain numbers in a database
DCOUNTADatabaseCounts nonblank cells in a database
DEC2BINEngineeringConverts a decimal number to binary
DEC2HEXEngineeringConverts a decimal number to hexadecimal
DELTAEngineeringTests whether two values are equal
DGETDatabaseExtracts from a database a single record that matches the specified criteria
DMAXDatabaseReturns the maximum value from selected database entries
DMINDatabaseReturns the minimum value from selected database entries
DOLLARTextConverts a number to text, using currency format
DSUMDatabaseAdds the numbers in the field column of records in the database that match the criteria
EDATEDateReturns the serial number of the date that is the indicated number of months before or after the start date
EOMONTHDateReturns the serial number of the last day of the month before or after a specified number of months
ERROR.TYPEInformationReturns a number corresponding to an error type
EVENMathematicalRounds a number up to the nearest even integer
EXACTTextChecks to see if two text values are identical
FACTMathematicalReturns the factorial of a number
FINDTextFinds one text value within another (case-sensitive)
FIXEDTextFormats a number as text with a fixed number of decimals
FLOORMathematicalRounds a number down, toward zero
FORECASTStatisticalReturns a value along a linear trend
FREQUENCYStatisticalReturns a frequency distribution as a vertical array
GCDMathematicalReturns the greatest common divisor
GESTEPEngineeringTests whether a number is greater than a threshold value
GROWTHStatisticalReturns values along an exponential trend
HEX2DECEngineeringConverts a hexadecimal number to decimal
HLOOKUPLookupLooks in the top row of an array and returns the value of the indicated cell
HOURDateConverts a serial number to an hour
IFLogicalSpecifies a logical test to perform
INDEXLookupUses an index to choose a value from a reference or array
INDIRECTLookupReturns a reference indicated by a text value
INFOInformationReturns information about the current operating environment
INTMathematicalRounds a number down to the nearest integer
ISBLANKInformationReturns TRUE if the value is blank
ISERRInformationReturns TRUE if the value is any error value except #N/A
ISERRORInformationReturns TRUE if the value is any error value
ISEVENInformationReturns TRUE if the number is even
ISLOGICALInformationReturns TRUE if the value is a logical value
ISNAInformationReturns TRUE if the value is the #N/A error value
ISNONTEXTInformationReturns TRUE if the value is not text
ISNUMBERInformationReturns TRUE if the value is a number
ISODDInformationReturns TRUE if the number is odd
ISREFInformationReturns TRUE if the value is a reference
ISTEXTInformationReturns TRUE if the value is text
LARGEStatisticalReturns the k-th largest value in a data set
LCMMathematicalReturns the least common multiple
LEFTTextReturns the leftmost characters from a text value
LENTextReturns the number of characters in a text string
LOOKUP (vector)LookupLooks up values in a vector or array
LOWERTextConverts text to lowercase
MATCHLookupLooks up values in a reference or array
MAXStatisticalReturns the maximum value in a list of arguments
MEDIANStatisticalReturns the median of the given numbers
MIDTextReturns a specific number of characters from a text string starting at the position you specify
MINStatisticalReturns the minimum value in a list of arguments
MINUTEDateConverts a serial number to a minute
MINVERSEMathematicalReturns the matrix inverse of an array
MMULTMathematicalReturns the matrix product of two arrays
MODMathematicalReturns the remainder from division
MODEStatisticalReturns the most common value in a data set
MONTHDateConverts a serial number to a month
MROUNDMathematicalReturns a number rounded to the desired multiple
NInformationReturns a value converted to a number
NAInformationReturns the error value #N/A
NETWORKDAYSDateReturns the number of whole workdays between two dates
NOTLogicalReverses the logic of its argument
NOWDateReturns the serial number of the current date and time
ODDMathematicalRounds a number up to the nearest odd integer
ORLogicalReturns TRUE if any argument is TRUE
PERMUTStatisticalReturns the number of permutations for a given number of objects
PIMathematicalReturns the value of Pi
POWERMathematicalReturns the result of a number raised to a power
PRODUCTMathematicalMultiplies its arguments
PROPERTextCapitalises the first letter in each word of a text value
QUARTILEStatisticalReturns the quartile of a data set
QUOTIENTMathematicalReturns the integer portion of a division
RANDMathematicalReturns a random number between 0 and 1
RANDBETWEENMathematicalReturns a random number between the numbers you specify
RANKStatisticalReturns the rank of a number in a list of numbers
REPLACETextReplaces characters within text
REPTTextRepeats text a given number of times
RIGHTTextReturns the rightmost characters from a text value
ROMANMathematicalConverts an arabic numeral to roman, as text
ROUNDMathematicalRounds a number to a specified number of digits
ROUNDDOWNMathematicalRounds a number down, toward zero
ROUNDUPMathematicalRounds a number up, away from zero
SECONDDateConverts a serial number to a second
SIGNMathematicalReturns the sign of a number
SLNFinancialReturns the straight-line depreciation of an asset for one period
SMALLStatisticalReturns the k-th smallest value in a data set
STDEVStatisticalEstimates standard deviation based on a sample
STDEVPStatisticalCalculates standard deviation based on the entire population
SUBSTITUTETextSubstitutes new text for old text in a text string
SUBTOTALMathematicalReturns a subtotal in a list or database
SUMMathematicalAdds its arguments
SUM_as_Running_TotalMathematicalSample
SUM_using_namesSampleUsing SUM(jan)
SUM_with_OFFSETLookupSample
SUMIFMathematicalAdds the cells specified by a given criteria
SUMPRODUCTMathematicalReturns the sum of the products of corresponding array components
SYDFinancialReturns the sum-of-years' digits depreciation of an asset for a specified period
T TextTextConverts its arguments to text
TEXTTextFormats a number and converts it to text
TIMEDateReturns the serial number of a particular time
TimesheetSampleSample
TIMEVALUEDateConverts a time in the form of text to a serial number
TODAYDateReturns the serial number of today's date
TRANSPOSELookupReturns the transpose of an array
TRENDStatisticalReturns values along a linear trend
TRIMTextRemoves spaces from text
TRUNCMathematicalTruncates a number to an integer
TYPEInformationReturns a number indicating the data type of a value
UPPERTextConverts text to uppercase
VALUETextConverts a text argument to a number
VARStatisticalEstimates variance based on a sample
VARPStatisticalCalculates variance based on the entire population
VLOOKUPLookupLooks in the first column of an array and moves across the row to return the value of a cell
WEEKDAYDateConverts a serial number to a day of the week
WORKDAYDateReturns the serial number of the date before or after a specified number of workdays
YEARDateConverts a serial number to a year
YEARFRACDateReturns the year fraction representing the number of whole days between start_date and end_date


Comments

Author: Ajay10 Sep 2010 Member Level: Silver   Points : 1

Hello Friend,

You have share the important Functions that are used in Excel, are helpful to the user, generally there are many user unaware of such kind functions and tools available on Excel. This is useful stuff


Thanks to share, Keep up the wonderful work.

lastly one suggestion, whenever you post an article use normal setting html tags, to increase visibility og your stuff

Author: satyajee srivastava29 Dec 2010 Member Level: Silver   Points : 1

Thanks dear
this is really a good stuff for excel.
Keep up the wonderful work



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: