ASP.NET MVC Controls | ComponentOne
Working with Controls / FlexSheet / Work with FlexSheet / Formulas in FlexSheet / In-built Formulas Supported in FlexSheet
In This Topic
    In-built Formulas Supported in FlexSheet
    In This Topic

    The FlexSheet control supports following in-built formulas.

    Name Description
    abs Returns the absolute value of a number.
    acos Returns the arccosine of a number.
    and Returns TRUE if all of its arguments are TRUE.
    asin Returns the arcsine of a number.
    atan Returns the arctangent of a number.
    atan2 Returns the arctangent from x- and y-coordinates.
    average Returns the average of its arguments.
    ceiling Rounds a number to the nearest integer or to the nearest multiple of significance.
    char Returns the character specified by the code number.
    choose Chooses a value from a list of values.
    code Returns a numeric code for the first character in a text string.
    column Returns the column number of a reference.
    columns Returns the number of columns in a reference.
    concatenate Joins several text items into one text item.
    cos Returns the cosine of a number.
    count Counts how many numbers are in the list of arguments.
    counta Counts how many values are in the list of arguments.
    countblank Counts the number of blank cells within a range.
    countif Counts the number of cells within a range that meet the given criteria.
    countifs Counts the number of cells within a range that meet multiple criteria.
    date Returns the serial number of a particular date.
    datediff Calculates the number of days, months, or years between two dates.
    day Converts a serial number to a day of the month.
    dcount Counts the cells that contain numbers in a database.
    exp Returns e raised to the power of a given number.
    false Returns the logical value FALSE.
    find Finds one text value within another (case-sensitive).
    floor Rounds a number down, toward zero.
    hlookup Looks in the top row of an array and returns the value of the indicated cell.
    hour Converts a serial number to an hour.
    if Specifies a logical test to perform.
    index Uses an index to choose a value from a reference.
    left Returns the leftmost characters from a text value.
    len Returns the number of characters in a text string.
    ln Returns the natural logarithm of a number.
    lower Converts text to lowercase.
    max Returns the maximum value in a list of arguments.
    mid Returns a specific number of characters from a text string starting at the position you specify.
    min Returns the minimum value in a list of arguments.
    mod Returns the remainder from division.
    month Converts a serial number to a month.
    not Reverses the logic of its argument.
    now Returns the serial number of the current date and time.
    or Returns TRUE if any argument is TRUE.
    pi Returns the value of pi.
    power Returns the result of a number raised to a power.
    product Multiplies its arguments.
    proper Capitalizes the first letter in each word of a text value.
    rand Returns a random number between 0 and 1.
    rank Returns the rank of a number in a list of numbers.
    rate Returns the interest rate per period of an annuity.
    replace Replaces characters within text.
    rept Repeats text a given number of times.
    right Returns the rightmost characters from a text value.
    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 a reference.
    search Finds one text value within another (not case-sensitive).
    sin Returns the sine of the given angle.
    sqrt Returns a positive square root.
    stdev Estimates standard deviation based on a sample.
    stdevp Calculates standard deviation based on the entire population.
    substitute Substitutes new text for old text in a text string.
    subtotal Returns a subtotal in a list or database.
    sum Adds its arguments.
    sumif Adds the cells specified by a given criteria.
    sumifs Adds the cells in a range that meet multiple criteria.
    tan Returns the tangent of a number.
    text Formats a number and converts it to text.
    time Returns the serial number of a particular time.
    today Returns the serial number of today's date.
    trim Removes spaces from text.
    true Returns the logical value TRUE.
    trunc Truncates a number to an integer.
    upper Converts text to uppercase.
    value Converts a text argument to a number.
    var Estimates variance based on a sample.
    varp Calculates variance based on the entire population.
    year Converts a serial number to a year.

    See Also

    Reference