Home » Excel, VBA & Power BI » Excel Functions

Excel Functions

Article byDheeraj Vaidya, CFA, FRM

What Are Excel Functions?

Below is the list of the most important 100+ Excel functions and their formula usage. These Excel functions are categorized into the following:

Key Takeaways

  • Excel functions are classified into financial, logical, text, date and time, lookup & reference, math, statistical, and information functions.
  • Excel functions like IRR, MIRR, NPER, NPV, PMT, PPMT, Price, PV, Interest Rate, XIRR, and Yield help find investment interest, understand potential returns and expenses, and provide insights into the Internal Rate of Return.
  • Excel functions are essential for converting numbers to ASCII characters. The AND function returns TRUE if all conditions are true, while the IFERROR function returns a specific value if an error is returned.

List Of Excel Functions

#1 – Financial Functions


FV in ExcelFV In ExcelThe FV function in Excel is a built-in financial function that can also be referred to as the future value function. This function is very useful in calculating the future value of any investment made by anyone. It has some dependent arguments, which are the constant interest, periods, and payments.read more Calculate the future value of an investment at a specified rate of interest
rate
nper
pmt
pv
type
IPMT IPMTThe IPMT function calculates the interest to be paid on a given loan with constant interest and periodic payments. It is a financial function that computes the interest portion of a payment for a given period.read more Calculate the interest of an investment for a specific period.
rate
per
nper
pv
fv
type
IRR This excel function is simply the Internal Rate of Return for your investment in a series of cash flows.
values
guess
MIRR in Excel MIRR In ExcelMIRR or (modified internal rate of return) in excel is an in-build financial function to calculate the MIRR for the cash flows supplied with a period. It takes the initial investment, interest rate and the interest earned from the earned amount and returns the MIRR.read more It is the Modified Internal Rate of Return, which returns the percentage by considering both the finance and reinvestment rates.
values
finance_rate
reinvest_rate
NPER NPERNPER, commonly known as the number of payment periods for a loan, is a financial term and an inbuilt financial function in Excel that can be used to calculate NPER for any loan. This formula takes rate, payment made, present value and future value as input from a user.read more The number of installments or EMIs required to clear off the loan.
rate
pmt
pv
fv
type
NPV Net Present Value is the value of future cash inflows and outflows by considering the current discount rate.
rate
value1
value2
PMT PMTPMT function is an advanced financial function to calculate the monthly payment against the simple loan amount. You have to provide basic information, including loan amount, interest rate, and duration of payment, and the function will calculate the payment as a result.read more This Excel function returns the per month payment required to repay the loan.
rate
nper
pv
fv
type
PPMT in Excel PPMT In ExcelThe PPMT function in Excel is a financial function that calculates the payment for a given principal and returns an integer result. This function can be used to calculate the principal amount of an installment for any period.read more It returns only the principal amount for an investment or loan
per
nper
pv
fv
type
PRICE in Excel PRICE In ExcelThe price function in Excel is a financial function that calculates the original value or face value of a stock for per 100 dollars, assuming interest is paid periodically.read more It returns the redemption value per 100 face value.
settlement
maturity
rate
yld
redemption
frequency
basis
PV in Excel PV In ExcelPV, or present value, is a function that is used to calculate the current present value of any investment. It is determined by the investment rate and the number of payment periods, with the future value as an input.read more It gives the present value of an investment by considering constant interest rates and payments
rate
nper
pmt
fv
type
RATE in Excel RATE In ExcelRate function in excel is used to calculate the rate levied on a period of a loan. The required inputs for this function are number of payment periods, pmt, present value and future value.read more It returns the interest rate for an investment or loan.
nper
pmt
pv
fv
type
guess
XIRR XIRRThe XIRR function, also known as the Extended Internal Rate of Return function in Excel, is used to calculate returns based on multiple investments made for a series of non-periodic cash flows.read more It returns the internal rate of return without any specific periodic period.
values
dates
guess
YIELD It estimates the amount earned on investment security over some time.
 

#2 – Logical Functions in Excel

AND If all the supplied conditions are true, it will return TRUE or else FALSE.
logical1
logical2
IF This tests the logic given; it the condition is true, then we can get whatever the result we want if FALSE also we can other than the TRUE result value.
logical_test
value_if_true
value_if_false
IFERROR in Excel IFERROR In ExcelThe IFERROR function in Excel checks a formula (or a cell) for errors and returns a specified value in place of the error.read more This returns the specific value if the applied formula returns an error result.
value
value_if_error
NOT This works indirectly, if the value is TRUE, it will result in FLASE, and if the result is FALSE, it will return TRUE.
logical
OR in Excel OR In ExcelThe OR function in Excel is used to test various conditions, allowing you to compare two values or statements in Excel. If at least one of the arguments or conditions evaluates to TRUE, it will return TRUE. Similarly, if all of the arguments or conditions are FALSE, it will return FASLE.read more This is just like the AND function in excel, but if anyone of the supplied is true, it will return TRUE.
logical1
logical2
TRUE This is the formula to get TRUE value without manual typing
–

#3 – Text Functions in Excel

CHAR This excel function converts numbers to characters based on the American Standard Code For Information Interchange (ASCII).
number
CLEAN It removes only non-printable values.
text
CODE CODEIn Excel, the Code Function is used to determine the code of a character in a string. It only finds the code for the first character, thus if we use this formula as =Code(“Anand”) and =Code(“An”), the result will be 65, because the code for character A is 65.read more This returns the numerical code for an alphabetic word.
text
EXACT in Excel EXACT In ExcelThe exact function is a logical function in excel used to compare two strings or data with each other, and it gives us the result whether the both data are an exact match or not. This function is a logical function, so it provides true or false as a result.read more This tests two cell values, whether they are exact, are not.
text1
text2
LEFT This will get the value from the left-hand side of a string based on the number of characters we specify.
text
num_chars
LEN in Excel LEN In ExcelThe Len function returns the length of a given string. It calculates the number of characters in a given string as input. It is a text function in Excel as well as an inbuilt function that can be accessed by typing =LEN( and entering a string as input.read more This excel function returns the numbers of characters in a cell. Space is also a character.
text
MID in Excel MID In ExcelThe mid function in Excel is a text function that finds strings and returns them from any mid-part of the spreadsheet. read more This can fetch the data from the middle of the supplied value.
text
start_num
num_chars
PROPER This will arrange the text properly by changing the first character to an uppercase letter.
text
REPLACE This excel function replaces the text with new text from the specified position
old_text
start_num
num_chars
new_text
REPT This will repeat the supplied character based on the number we specify.
text
number_times
RIGHT in Excel RIGHT In ExcelRight function is a text function which gives the number of characters from the end from the string which is from right to left. For example, if we use this function as =RIGHT ( “ANAND”,2) this will give us ND as the result.read more This will get the value from the right-hand side of a string based on the number of characters we specify.
text
num_chars
SEARCH in Excel SEARCH In ExcelSearch function gives the position of a substring in a given string when we give a parameter of the position to search from. As a result, this formula requires three arguments. The first is the substring, the second is the string itself, and the last is the position to start the search.read more This will return the position of the supplied character in the specific value.
find_text
within_text
start_num
SUBSTITUTE in Excel SUBSTITUTE In ExcelSubstitute function in excel is a very useful function which is used to replace or substitute a given text with another text in a given cell, this function is widely used when we send massive emails or messages in a bulk, instead of creating separate text for every user we use substitute function to replace the information.read more This excel function substitutes the existing character with a new character.
text
old_text
new_text
instance_num
TEXT This will convert the value to text based on the format we specify.
value
format_text
TRIM in Excel TRIM In ExcelThe Trim function in Excel does exactly what its name implies: it trims some part of any string. The function of this formula is to remove any space in a given string. It does not remove a single space between two words, but it does remove any other unwanted spaces.read more This eliminates unnecessary spaces or trailing spaces.
text
VALUE in Excel VALUE In ExcelIn Excel, the value function returns the value of a text representing a number. So, if we have a text with the value $5, we can use the value formula to get 5 as a result, so this function gives us the numerical value represented by a text.read more This will convert the numerical values, which are in text format to number format.
text

#4 – Date And Time Functions

DATE This excel function requires three elements, year, month, and day. It will format the supplied numbers as a date.
year
month
day
DAY It extracts the day number from the supplied date.
serial_number
EDATE in Excel EDATE In ExcelEDATE is a date and time function in excel which adds a given number of months into a date and gives us a date in a numerical format of date. It takes dates and integers as input, the output returned by this function is also a date value. read more It is used to get a date on the same day of the month, x months in the past or future.
start_date
months
EOMONTH EOMONTHEOMONTH is a worksheet date function in excel which calculates the end of the month for the given date by adding a specified number of months to the arguments. This function takes two arguments: the date and another as integer, and the output is in the date format.read more This excel function returns the end of the month for the supplied date.
start_date
months
NOW in Excel NOW In ExcelIn an excel worksheet, the NOW function is used to display the current system date and time. The syntax for using this function is quite simple =NOW ().read more It returns the current date and time.
–
TIME in Excel TIME In ExcelTime is a time worksheet function in Excel that is used to calculate time based on the inputs provided by the user. The arguments can take the following formats: hours, minutes, and seconds.read more It requires three elements, hour, minute, and second.
hour
minute
second
TODAY in Excel TODAY In ExcelToday function is a date and time function that is used to find out the current system date and time in excel. This function does not take any arguments and auto-updates anytime the worksheet is reopened. This function just reflects the current system date, not the time.read more It gives the current date.
–
WEEKDAY in Excel WEEKDAY In ExcelThe WEEKDAY function in excel returns the day corresponding to a specified date. The date is supplied as an argument to this function. read more It returns the weekday of the supplied date.
serial_number
return_type
WORKDAY in Excel WORKDAY In ExcelThe WORKDAY function returns the forthcoming work day after a given number of days from the start date. It has an optional argument for holidays that, if not provided, automatically considers weekends (Saturdays and Sundays) to be holidays.read more This excel function returns the date from the supplied date based on the number of days we specify.
start_date
days
holidays
YEAR in Excel YEAR In ExcelThe year function in excel is a date function to calculate the year from a given date. This function takes a serial number as an argument and returns a four-digit numeric value representing the year of the given date, formula = year (serial number)read more This function extracts the year from the supplied date.
serial_number

#5 – Lookup & Reference Functions

ADDRESS This will create the cell reference or address of the cell as a text value.
row_num
column_num
abs_num
a1
sheet_text
CHOOSE This excel function chooses the value from various values.
index_num
value1
value2
COLUMN This function returns the selected column number
reference
COLUMNS in Excel COLUMNS In ExcelThe COLUMNS function returns the total number of columns in the given array or collection of references.read more It will return how many columns are selected
array
GETPIVOTDATA GETPIVOTDATAThe GetPivotData function in Excel is a query function that fetches values from a pivot table based on specific criteria such as the pivot table's structure or the reference provided to the function.read more It extracts data from the pivot tablePivot TableA Pivot Table is an Excel tool that allows you to extract data in a preferred format (dashboard/reports) from large data sets contained within a worksheet. It can summarize, sort, group, and reorganize data, as well as execute other complex calculations on it.read more from the specified row and from the specified column
data_field
pivot_table
field1
item1
HLOOKUP HLOOKUPHlookup is a referencing worksheet function that finds and matches the value from a row rather than a column using a reference. Hlookup stands for horizontal lookup, in which we search for data in rows horizontally.read more It extracts data which is there horizontally based on the lookup value.
lookup_value
table_array
row_index_num
range_lookup
HYPERLINKHYPERLINKA hyperlink is an inbuilt function in excel used to create hyperlinks for a particular cell. When the hyperlink is created, it redirects to a specific webpage. The hyperlink formula has two arguments, one is the URL while the other is the name we provide to the URL.read more This creates a URL to open the data, which is where your PC or laptop.
link_location
friendly_name
INDEX It returns the value from the lookup value.
array
row_num
column_num
area_num
INDIRECT Function in Excel INDIRECT Function In ExcelThe INDIRECT excel function is used to indirectly refer to cells, cell ranges, worksheets, and workbooks.read more This indirectly refers to the other cell from a different cell.
ref_text
a1
LOOKUP in Excel LOOKUP In ExcelThe LOOKUP excel function searches a value in a range (single row or single column) and returns a corresponding match from the same position of another range (single row or single column). The corresponding match is a piece of information associated with the value being searched. read more It looks for a value in one row and one column
lookup_value
lookup_vector
result_vector
MATCH MATCHThe MATCH function looks for a specific value and returns its relative position in a given range of cells. The output is the first position found for the given value. Being a lookup and reference function, it works for both an exact and approximate match. For example, if the range A11:A15 consists of the numbers 2, 9, 8, 14, 32, the formula “MATCH(8,A11:A15,0)” returns 3. This is because the number 8 is at the third position. read more This returns the row number of a lookup value from the array.
lookup_value
lookup_array
match_type
OFFSET in Excel OFFSET In ExcelThe OFFSET function in excel returns the value of a cell or a range (of adjacent cells) which is a particular number of rows and columns from the reference point. read more This function returns a reference to a range.
reference
rows
cols
height
width
ROW Returns the first-row number in the reference provided
reference
Transpose in Excel Transpose In ExcelThe TRANSPOSE function in excel helps rotate (switch) the values from rows to columns and vice versa. Being a part of the Excel lookup and reference functions, its purpose is to organize the data in the desired format. To execute the formula, the exact size of the range to be transposed is selected and the CSE key (“Control+Shift+Enter”) is pressed. read more This function is used to switch cells between rows and columns.
array
VLOOKUP VLOOKUPThe VLOOKUP excel function searches for a particular value and returns a corresponding match based on a unique identifier. A unique identifier is uniquely associated with all the records of the database. For instance, employee ID, student roll number, customer contact number, seller email address, etc., are unique identifiers. read more This excel function returns the value of a lookup value from another table, which is there vertically.
lookup_value
table_array
col_index_num
range_lookup

#6 – Math Functions

ABS This function converts all the negative numbers to positive numbers.
number
AGGREGATE This excel function supplies some of the important formulas like Average, Count, Max, Min, and many other functions by ignoring error values
function_num
options
array
k
CEILING Excel Function CEILING Excel FunctionThe CEILING function is very similar to the FLOOR function in terms of functionality. However, the result is the polar opposite, with the floor function giving a less significant result. The ceiling formula, on the other hand, gives result with a higher significance.read more Returns a rounded number based on a multiple significance.
number
significance
mode
COMBIN Excel Function COMBIN Excel FunctionCOMBIN function in excel is the combination function to calculate possible combinations for two given numbers. This function takes two arguments. One is the number and number chosen. If the number is 5 and the number chosen is 1, then there are 5 combinations and 5 as a result.read more This function returns the number of combinations for a specified number of items.
number
number_chosen
EVEN This excel function converts all the odd numbers to even numbers.
number
EXP Excel Function EXP Excel FunctionExponential Excel function(EXP) is an inbuilt function in excel used to calculate the exponent raised to the power of any number you provide. In this function the exponent is constant and is also known as the base of the natural algorithm.read more It raises the supplied number to the power of e.
number
INT in Excel INT In ExcelINT or integer function in excel returns the nearest integer of a given number and is used when we have many data sets and each data in a different format.read more This function is responsible for returning a number’s integer portion.
number
LN Excel LN ExcelLN function calculates the logarithm of a given number which takes a single number as the argument and gives the result as the logarithm.read more This function is used to calculate the natural logarithm of a number.
number
LOG in Excel LOG In ExcelThe LOG function returns the logarithm of a given number. The number's base, on the other hand, is supposed to be provided by the user.read more It returns the logarithm of a number to the base user gives
number
base
ODD in Excel ODD In ExcelODD Function is an inbuilt function in excel as the name suggests it rounds any given number to its odd value, the number can be both negative or positive.read more This function converts all the even numbers to ODD numbers.
number
POWER in Excel POWER In ExcelPOWER function calculates the power of a given number or base. To use this function you can use the keyword =POWER( in a cell and provide two arguments one as number and another as power.read more This function raises the base number to a different number of times at the top of the base.
number
power
PRODUCT in Excel PRODUCT In ExcelProduct excel function is an inbuilt mathematical function which is used to calculate the product or multiplication of the given numbers. If you provide this formula arguments as 2 and 3 as =PRODUCT(2,3) then the result displayed is 6.read more This function simply does the multiplication of two supplied numbers.
number1
number2
RAND in ExcelRAND In ExcelThe RAND function in Excel, also known as the random function, generates a random value greater than 0 but less than 1, with an even distribution among those numbers when used on multiple cells. read more It returns values that are greater than zero but less than 1. This is a volatile function.
–
ROUND It either rounds up or rounds down to a specified number of decimals.
number
num_digits
ROUNDUP in ExcelROUNDUP In ExcelThe ROUNDUP excel function calculates the rounded value of the number to the upward side or the higher side. In other words, it rounds the number away from zero. Being an inbuilt function of Excel, it accepts two arguments–the “number” and the “num_of _digits.” For example, “=ROUNDUP(0.40,1)” returns 0.4. read more This excel function rounds the given floating-point number to a number of decimal places provided.
number
num_digits
ROUNDDOWN in ExcelROUNDDOWN In ExcelROUNDDOWN function is a built-in function in Microsoft Excel. It is used to round off the given number.read more To round off the given number, this function is used.
number
num_digits
SIGN This function calculates the sign of a supplied number.
number
SIN in ExcelSIN In ExcelSIN Excel function is an inbuilt trigonometric function in excel which is used to calculate the sine value of given number or in terms of trigonometry the sine value of a given angle, here the angle is a number in excel and this function takes only a single argument which is the input number provided.read more This function calculates the SIN of an angle
number
SQRT in ExcelSQRT In ExcelThe Square Root function is an arithmetic function built into Excel that is used to determine the square root of a given number. To use this function, type the term =SQRT and hit the tab key, which will bring up the SQRT function. Moreover, this function accepts a single argument.read more Find a number of positive square roots
number
SUBTOTAL in ExcelSUBTOTAL In ExcelThe SUBTOTAL excel function performs different arithmetic operations like average, product, sum, standard deviation, variance etc., on a defined range.read more This function ignores all the hidden rows and gives the calculation only for the visible rows.
function_num
ref1
SUMSUMThe SUM function in excel adds the numerical values in a range of cells. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. The values supplied to the function can be numbers, cell references or ranges.read more This excel function adds all the numerical values which are there in the range.
number1
number2
SUMIF in ExcelSUMIF In ExcelThe SUMIF Excel function calculates the sum of a range of cells based on given criteria. The criteria can include dates, numbers, and text. For example, the formula “=SUMIF(B1:B5, “<=12”)” adds the values in the cell range B1:B5, which are less than or equal to 12. read more This function adds the numbers based on the single criteria given by the user.
range
criteria
sum_range
TAN This function simultaneously does the summation as well as multiplication corresponding to the values.
array1
array2
array3
TAN in ExcelTAN In ExcelThe TAN Excel function is a trigonometric function built into Excel that is used to calculate the cosine value of a given number or, in terms of trigonometry, the cosine value of a given angle. In this case, the angle is a number in Excel, and this function accepts only one argument, which is the input number.read more This function returns the tangent of an angle.
number
TANH in ExcelTANH In ExcelIn trigonometry we have a term called hyperbolic tangent which is the ratio of the hyperbolic sine and cosine functions, to calculate this mathematical operation in excel we have an inbuilt trigonometric function known as TANH and it takes single argument as an input. read more TANH function gives the hyperbolic tangent of a given number, and the number is considered as an angle to radians.
number

#7 – Statistical Functions

AVERAGE This excel function returns the average value of the supplied numbers.
number1
number2
CORREL Excel FunctionCORREL Excel FunctionCORREL function is a statistical function in Excel. The CORREL formula finds out the coefficient between two variables and returns the coefficient of array1 and array2. The correlation coefficient determines the relationship between the two properties.read more  This is nothing but a correlation between two data sets.
array1
array2
COUNT This function counts all the numerical values in the supplied range.
value1
value2
COUNTIFCOUNTIFThe COUNTIF function in Excel counts the number of cells within a range based on pre-defined criteria. It is used to count cells that include dates, numbers, or text. For example, COUNTIF(A1:A10,”Trump”) will count the number of cells within the range A1:A10 that contain the text “Trump” read more This excel function counts only the value w specify
range
criteria
F.TEST in ExcelF.TEST In ExcelF-test in excel is a statistical tool that helps us decide whether the variances of two populations having normal distribution are equal or not. F-test is an essential part of the analysis of variance (ANOVA) model.read more This function is used to decide if two populations having normal distributionNormal DistributionNormal Distribution is a bell-shaped frequency distribution curve which helps describe all the possible values a random variable can take within a given range with most of the distribution area is in the middle and few are in the tails, at the extremes. This distribution has two key parameters: the mean (µ) and the standard deviation (σ) which plays a key role in assets return calculation and in risk management strategy.read more have similar variances or the standard deviation.
array1
array2
FORECAST Excel FormulaFORECAST Excel FormulaThe FORECAST function in Excel is used to calculate or predict the future value based on existing values and the statistical value of the forecast. If we know the past data, we may use the function to forecast the future value.read more This function calculates or estimates the sales values based on previous trends.
x
known_ys
known_xs
FREQUENCY in ExcelFREQUENCY In ExcelThe FREQUENCY function in Excel calculates the number of times a data values occurs within a given range of values and returns a vertical array of numbers corresponding to each value’s frequency within a range.read more This excel function shows how often a certain value is occurring in an array
data_array
bins_array
GROWTH It calculates the exponential growthCalculates The Exponential GrowthExponential Growth refers to the increase due to compounding of the data over time and follows a curve representing an exponential function. Exponential growth formula: Final value = Initial value * (1 + Annual Growth Rate/No of Compounding ) No. of years * No. of compoundingread more of given numbers based on two data sets.
known_ys
known_xs
new_xs
const
LARGE It is responsible for returning the nth largest value from a given set of values in the spreadsheet.
array
k
LINEST ExcelLINEST ExcelThe built-in LINEST Function in Excel calculates statistics for a line by the least-squares regression method & returns an array that defines the line proving to be well-suited for the given data. read more It is used to calculate a line’s stats.
known_ys
known_xs
const
stats
MAX in ExcelMAX In ExcelThe MAX Formula in Excel is used to calculate the maximum value from a set of data/array. It counts numbers but ignores empty cells, text, the logical values TRUE and FALSE, and text values.read more This function is given the maximum value from the supplied numbers.
number2
MEDIAN This function returns the middle value of the supplied numbers.
number1
number2
MIN in ExcelMIN In ExcelIn Excel, the MIN function is categorized as a statistical function. It finds and returns the minimum value from a given set of data/array.read more This function is given the minimum value from the supplied numbers.
number1
number2
MODE This excel function returns the MODE for each set of data.
number1
number2
NORMDISTNORMDISTNORMDIST or normal distribution is an inbuilt statistical function of excel that calculates the normal distribution of a data set with mean and standard deviation provided.read more It estimates the probability of the variables plotting below or above a certain value.
x
mean
standard_dev
cumulative
NORM.S.INVNORM.S.INVThe NORM.S.INV function determines the inverse of the normal distribution. For this function, the mean of the data set is always zero and the standard deviation is always one.read more This is the inverse of standard normal cumulative distribution.
Probability
PERCENTILE in ExcelPERCENTILE In ExcelThe PERCENTILE function is responsible for returning the nth percentile from a supplied set of values. read more This function returns the nth percentile of the set of values supplied.
array
k
QUARTILE in ExcelQUARTILE In ExcelQuartile functions are used to find the various quartiles of a data set and are part of Excel's statistical functions. There are three quartiles; the first quartile (Q1) is the middle number between the smallest value and the median value of a data set. The second quartile (Q2) is the median of the data. The third quartile (Q3) is the middle value between the median of the data set and the highest value.read more This function in excel is used to find the different quartiles of a data set.
array
quart
SLOPE in ExcelSLOPE In ExcelThe Slope function returns the slope of a regression line based on the data points recognized by known _y values and known _x values.read more This function calculates how steep the line is
known_ys
known_xs
SMALL in ExcelSMALL In ExcelThe SMALL Function in Excel returns the nth smallest value from a set of values. For example, 2nd smallest value, 3rd smallest value and so on.read more This function returns the nth smallest value of the set of values supplied.
array
k
STDEV.SSTDEV.SThe standard deviation shows the variability of the data values from the mean (average). In Excel, the STDEV and STDEV.S calculate sample standard deviation while STDEVP and STDEV.P calculate population standard deviation. STDEV is available in Excel 2007 and the previous versions. However, STDEV.P and STDEV.S are only available in Excel 2010 and subsequent versions. read more SD shows how data spread outs among data points.
number1
number2
T.TEST This function in excel calculates the probability associated with the student’s T-testT-testA T-test is a method to identify whether the means of two groups differ from one another significantly. It is an inferential statistics approach that facilitates the hypothesis testing.read more
array1
array2
tails
type
TREND This function calculates the linear trend according to the given linear data set.
known_ys
known_xs
new_xs
const

#8 – Information Functions

ISBLANK in ExcelISBLANK In ExcelISBLANK in Excel is a logical function that checks if a target cell is blank or not. It returns the output “true” if the cell is empty (blank) or “false” if the cell is not empty. It is also known as referencing worksheet function and is grouped under the information function of Excel read more It examines whether the supplied value is blank or not.
value
ISERROR in ExcelISERROR In ExcelISERROR is a logical function that determines whether or not the cells being referred to have an error. If an error is found, it returns TRUE; if no errors are found, it returns FALSE.read more It examines whether the supplied value is an error or not.
value
ISNAISNAThe ISNA function is an error handling function in Excel. It helps to find out whether any cell has a “#N/A error” or not. This function returns the value “true” if “#N/A error” is identified or "false" if not identified.read more It examines whether the supplied value is equal to #N/A or not.
value
ISNUMBERISNUMBERISNUMBER function in excel is an information function that checks if the referred cell value is numeric or non-numeric.read more This function in excel testsExcel TestsThe Excel Test is a tool used by employers to assess their employees' Excel knowledge during the recruitment process. The goal is to assess skill level in Excel as it reduces human work and makes it very simple.read more whether the supplied value is a number or not.
value

Frequently Asked Questions

1. Why are Excel functions useful?

Excel functions are crucial for converting numbers to ASCII characters, with the AND function indicating true conditions and the IFERROR function providing a specific value if an error is returned.

2. What is Excel function?

Functions are predefined formulas in Excel that perform calculations using specific arguments in a specific order and can be found on the Formulas tab on the Ribbon, enabling simple or complex calculations.

3. What are the rules of functions in Excel?

To enter a function in Excel, one must use the = sign, a valid Excel name (e.g., SUM, AVERAGE), followed by an opening and closing parenthesis and enclosed in a parenthesis with arguments.

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *