Businesslogic Excel Function Support

Businesslogic.online supports over 260 Microsoft Excel functions, allowing you to perform advanced calculations, create robust automation, and streamline your workflows. Below is an overview of some supported functions, grouped by categories, to help you understand their use and applicability.

Complete list of supported Excel functions

A

  • ABS: Returns the absolute value of a number.
  • ACOS: Returns the arccosine of a number in radians.
  • ACOSH: Returns the inverse hyperbolic cosine of a number.
  • ADDRESS: Creates a cell reference as text based on row and column numbers.
  • AND: Returns TRUE if all arguments are TRUE.
  • AREAS: Returns the number of areas in a reference.
  • ASIN: Returns the arcsine of a number in radians.
  • ASINH: Returns the inverse hyperbolic sine of a number.
  • ATAN: Returns the arctangent of a number in radians.
  • ATAN2: Returns the arctangent of coordinates x and y.
  • ATANH: Returns the inverse hyperbolic tangent of a number.
  • AVEDEV: Calculates the average of absolute deviations from the mean.
  • AVERAGE: Computes the arithmetic mean of a range.
  • AVERAGEA: Calculates the average, including text (counted as 0).

B

  • BESSELI: Computes the modified Bessel function of the first kind.
  • BESSELJ: Computes the Bessel function of the first kind.
  • BESSELK: Computes the modified Bessel function of the second kind.
  • BESSELY: Computes the Bessel function of the second kind.
  • BETADIST: Returns the beta cumulative distribution function.
  • BETAINV: Returns the inverse of the beta cumulative distribution function.
  • BIN2DEC: Converts a binary number to decimal.
  • BIN2HEX: Converts a binary number to hexadecimal.
  • BIN2OCT: Converts a binary number to octal.
  • BINOMDIST: Calculates probabilities in a binomial distribution.

C

  • CEILING: Rounds a number up to the nearest multiple.
  • CELL: Returns information about a cell (e.g., format, location).
  • CHAR: Converts a number into the corresponding character.
  • CHIDIST: Returns the one-tailed probability of the chi-squared distribution.
  • CHIINV: Returns the inverse of the chi-squared probability.
  • CHOOSE: Selects a value from a list based on an index number.
  • CLEAN: Removes all non-printable characters from text.
  • CODE: Returns the numeric code of a character.
  • COLUMN: Returns the column number of a reference.
  • COLUMNS: Returns the number of columns in an array.
  • CONCATENATE: Combines text strings into one.
  • CONFIDENCE: Calculates the confidence interval for a population mean.
  • COMPLEX: Creates a complex number using real and imaginary parts.
  • CONVERT: Converts a number from one measurement system to another.
  • CORREL: Calculates the correlation coefficient of two data sets.
  • COS: Returns the cosine of an angle in radians.
  • COSH: Returns the hyperbolic cosine of a number.
  • COUNT: Counts the number of numerical values in a range.
  • COUNTA: Counts non-blank cells in a range.
  • COUNTBLANK: Counts blank cells in a range.
  • COUNTIF: Counts cells that meet a specified condition.
  • COUPDAYBS: Calculates days from the coupon start to settlement.
  • COUPDAYS: Returns total days in the coupon period.
  • COUPDAYSNC: Calculates days from settlement to next coupon date.
  • COUPNCD: Returns the next coupon date after the settlement date.
  • COUPNUM: Returns the number of coupons payable before maturity.
  • COUPPCD: Returns the previous coupon date.
  • COVAR: Returns the covariance of two data sets.
  • CRITBINOM: Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion.

D

  • CUMIPMT: Returns the cumulative interest paid on a loan.
  • CUMPRINC: Calculates cumulative principal paid on a loan.
  • DATE: Creates a date from year, month, and day values.
  • DATEDIF: Calculates the difference between two dates in years, months, or days.
  • DATEVALUE: Converts a date in text format to a serial number.
  • DAVERAGE: Returns the average of selected database entries.
  • DAY: Extracts the day of the month from a date.
  • DAYS360: Calculates days between two dates on a 360-day year.
  • DB: Returns depreciation using the fixed-declining method.
  • DCOUNT: Counts numeric values that meet a specified condition.
  • DCOUNTA: Counts non-blank values that meet a specified condition.
  • DDB: Returns depreciation using the double-declining method.
  • DEC2BIN: Converts a decimal number to binary.
  • DEC2HEX: Converts a decimal number to hexadecimal.
  • DEC2OCT: Converts a decimal number to octal.
  • DEGREES: Converts radians to degrees.
  • DELTA: Tests if two values are equal.
  • DEVSQ: Calculates the sum of squared deviations from the mean.

E

  • EDATE: Returns a date a specified number of months before or after the start date.
  • EFFECT: Calculates the effective annual interest rate.
  • EOMONTH: Returns the last day of the month, a specified number of months before or after a start date.
  • ERF: Returns the error function.
  • ERFC: Returns the complementary error function.
  • ERROR.TYPE: Returns a number corresponding to an error type.
  • EVEN: Rounds a number up to the nearest even integer.
  • EXACT: Checks if two text strings are exactly the same.
  • EXP: Returns e raised to the power of a number.
  • EXPONDIST: Returns the exponential distribution.

F

  • FACT: Returns the factorial of a number.
  • FACTDOUBLE: Returns the double factorial of a number.
  • FALSE: Returns the logical value FALSE.
  • FDIST: Returns the F probability distribution.
  • FIND: Finds a substring within a string and returns its position.
  • FINV: Returns the inverse of the F probability distribution.
  • FISHER: Returns the Fisher transformation.
  • FISHERINV: Returns the inverse of the Fisher transformation.
  • FIXED: Formats a number as text with a fixed number of decimals.
  • FLOOR: Rounds a number down to the nearest multiple of a significance value.
  • FORECAST: Calculates a predicted value based on a linear trend.
  • FTEST: Returns the result of an F-test.
  • FV: Calculates the future value of an investment.
  • FVSCHEDULE: Calculates the future value of an investment with a variable interest rate.

G

  • GAMMADIST: Returns the gamma distribution.
  • GAMMAINV: Returns the inverse of the gamma cumulative distribution.
  • GAMMALN: Returns the natural logarithm of the gamma function.
  • GCD: Returns the greatest common divisor of integers.
  • GEOMEAN: Returns the geometric mean of a data set.
  • GESTEP: Tests if a number is greater than or equal to a step value.
  • GROWTH: Calculates predicted exponential growth based on known data.

H

  • HARMEAN: Returns the harmonic mean of a data set.
  • HEX2BIN: Converts a hexadecimal number to binary.
  • HEX2DEC: Converts a hexadecimal number to decimal.
  • HEX2OCT: Converts a hexadecimal number to octal.
  • HLOOKUP: Looks for a value in the first row of a range and returns a value from another row.
  • HOUR: Extracts the hour from a time.
  • HYPERLINK: Creates a hyperlink.

I

  • IF: Performs a logical test and returns one value for TRUE and another for FALSE.
  • IMABS: Returns the absolute value of a complex number.
  • IMAGINARY: Returns the imaginary coefficient of a complex number.
  • IMARGUMENT: Returns the argument (angle) of a complex number.
  • IMCONJUGATE: Returns the complex conjugate of a complex number.
  • IMCOS: Returns the cosine of a complex number.
  • IMDIV: Divides two complex numbers.
  • IMEXP: Returns the exponential of a complex number.
  • IMLN: Returns the natural logarithm of a complex number.
  • IMLOG10: Returns the base-10 logarithm of a complex number.
  • IMLOG2: Returns the base-2 logarithm of a complex number.
  • IMPOWER: Returns a complex number raised to a power.
  • IMPRODUCT: Returns the product of complex numbers.
  • IMREAL: Returns the real coefficient of a complex number.
  • IMSIN: Returns the sine of a complex number.
  • IMSQRT: Returns the square root of a complex number.
  • IMSUB: Subtracts two complex numbers.
  • IMSUM: Adds two or more complex numbers.
  • INDEX: Returns the value of a cell at a given position in a range.
  • INDIRECT: Returns the reference specified by a text string.
  • INFO: Returns information about the current operating environment.
  • INT: Rounds a number down to the nearest integer.
  • IPMT: Returns the interest payment for an investment for a given period.
  • IRR: Returns the internal rate of return for a series of cash flows.

L

  • LCM: Returns the least common multiple of integers.
  • LEFT: Returns the specified number of characters from the start of a text string.
  • LEN: Returns the number of characters in a text string.
  • LN: Returns the natural logarithm of a number.
  • LOG: Returns the logarithm of a number with a specified base.
  • LOG10: Returns the base-10 logarithm of a number.
  • LOGINV: Returns the inverse of the lognormal cumulative distribution.
  • LOGNORMDIST: Returns the lognormal cumulative distribution.
  • LOOKUP: Looks up a value from a single row or column and returns a corresponding value.
  • LOWER: Converts text to lowercase.

M

  • MATCH: Searches for a value in a range and returns its relative position.
  • MAX: Returns the largest value in a range.
  • MAXA: Returns the largest value in a range, including logical values and text.
  • MEDIAN: Returns the median of a range.
  • MID: Returns a specific number of characters from a text string, starting at a specified position.
  • MIN: Returns the smallest value in a range.
  • MINA: Returns the smallest value in a range, including logical values and text.
  • MINUTE: Extracts the minute from a time.
  • MIRR: Returns the modified internal rate of return for a series of cash flows.
  • MOD: Returns the remainder after a number is divided by a divisor.
  • MODE: Returns the most frequently occurring value in a range.
  • MONTH: Extracts the month from a date.
  • MROUND: Rounds a number to the nearest multiple.

N

  • N: Converts a value to a number.
  • NA: Returns the #N/A error value.
  • NETWORKDAYS: Returns the number of whole working days between two dates.
  • NOT: Reverses the logic of its argument (TRUE becomes FALSE and vice versa).
  • NOW: Returns the current date and time.
  • NPER: Returns the number of payment periods for an investment.
  • NPV: Returns the net present value of an investment.

O

  • OCT2BIN: Converts an octal number to binary.
  • OCT2DEC: Converts an octal number to decimal.
  • OCT2HEX: Converts an octal number to hexadecimal.
  • ODD: Rounds a number up to the nearest odd integer.
  • OFFSET: Returns a reference offset from a given range.
  • OR: Returns TRUE if any of the arguments are TRUE.

P

  • PEARSON: Returns the Pearson product-moment correlation coefficient.
  • PERCENTILE: Returns the k-th percentile of a data set.
  • PERCENTRANK: Returns the rank of a value in a data set as a percentage.
  • PERMUT: Returns the number of permutations for a given number of objects.
  • PI: Returns the value of pi.
  • PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.
  • POISSON: Returns the Poisson distribution.
  • POWER: Returns the result of a number raised to a power.
  • PRICE: Returns the price per $100 face value of a security.
  • PROPER: Capitalizes the first letter in each word of a text string.
  • PV: Returns the present value of an investment.

Q

  • QUOTIENT: Returns the integer portion of a division.

R

  • RADIANS: Converts degrees to radians.
  • RAND: Returns a random number between 0 and 1.
  • RANDBETWEEN: Returns a random integer between two specified numbers.
  • RATE: Returns the interest rate per period of an investment.
  • RECEIVED: Returns the amount received at maturity for a fully invested security.
  • REPLACE: Replaces part of a text string with another text string.
  • REPT: Repeats text a specified number of times.
  • RIGHT: Returns the specified number of characters from the end of a text string.
  • ROMAN: Converts a number to Roman numerals.
  • ROUND: Rounds a number to a specified number of digits.
  • ROUNDDOWN: Rounds a number down toward zero.
  • ROUNDUP: Rounds a number up away from zero.
  • ROW: Returns the row number of a reference.
  • ROWS: Returns the number of rows in an array.

S

  • SEARCH: Finds one text string within another and returns its position.
  • SECOND: Extracts the second from a time.
  • SIGN: Returns the sign of a number.
  • SIN: Returns the sine of an angle.
  • SINH: Returns the hyperbolic sine of a number.
  • SLN: Returns the straight-line depreciation of an asset.
  • SQRT: Returns the square root of a number.
  • SQRTPI: Returns the square root of a number multiplied by pi.
  • STANDARDIZE: Returns a normalized value based on mean and standard deviation.
  • STDEV: Returns the standard deviation of a data set.
  • STDEVA: Returns the standard deviation of a data set, including text and logical values.
  • STDEVP: Returns the standard deviation for an entire population.
  • STDEVPA: Returns the standard deviation for an entire population, including text and logical values.
  • SUBTOTAL: Returns a subtotal in a list or database.
  • SUM: Adds numbers.
  • SUMIF: Adds numbers that meet a specified condition.
  • SUMPRODUCT: Multiplies corresponding elements in arrays and returns the sum of the results.
  • SUMSQ: Returns the sum of the squares of the arguments.
  • SYD: Calculates the sum-of-years' digits depreciation of an asset.

T

  • T: Converts its arguments to text.
  • TAN: Returns the tangent of an angle.
  • TANH: Returns the hyperbolic tangent of a number.
  • TDIST: Returns the Student's t-distribution.
  • TEXT: Formats a number and converts it to text.
  • TIME: Returns a time from hour, minute, and second inputs.
  • TIMEVALUE: Converts a time in text format to a serial number.
  • TINV: Returns the inverse of the Student's t-distribution.
  • TODAY: Returns the current date.
  • TRIM: Removes all extra spaces from text, leaving single spaces.
  • TRUE: Returns the logical value TRUE.
  • TRUNC: Truncates a number to an integer by removing the fractional part.
  • TYPE: Returns the type of a value.

U

  • UPPER: Converts text to uppercase.
  • USDOLLAR: Converts a number to text in the currency format.

V

  • VALUE: Converts text that appears as a number to a number.
  • VAR: Estimates variance based on a sample.
  • VARA: Estimates variance based on a sample, including logical values and text.
  • VARP: Calculates variance based on an entire population.
  • VARPA: Calculates variance for an entire population, including logical values and text.
  • VDB: Returns depreciation for a specified period using the variable-declining balance method.
  • VLOOKUP: Looks for a value in the first column of a range and returns a value in the same row from another column.

W

  • WEEKDAY: Returns the day of the week corresponding to a date.
  • WEIBULL: Returns the Weibull distribution.
  • WORKDAY: Returns a date that is a specified number of workdays before or after a start date.

Y

  • YEAR: Returns the year of a date.
  • YEARFRAC: Calculates the fraction of the year between two dates.
  • YIELD: Returns the yield on a security.
  • YIELDDISC: Returns the annual yield for a discounted security.

Z

  • ZTEST: Returns the one-tailed probability-value of a z-test.