Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki Mathematical Functions
    • Sign In
    • -gINT | Keynetix Wiki
      • +gINT
      • +gINT Collector
      • +gINT Civil Tools
      • -Keynetix
        • +Installing or Upgrading to CONNECT Edition
        • +Archive Webinars
        • +HoleBASE
        • +HoleBASE Civil Extension
        • +HoleBASE Data Entry
        • +HoleBASE Excel Extension
        • -HoleBASE Template Studio
          • +HoleBASE Template Studio:Getting Started
          • -Template Studio: FAQs
            • +Designing Depth Related Areas
            • -Expressions
              • Excel Functions
              • How To Display a Full Location Type Rather than an Abbreviation
              • How To edit the Stratum Detail Descriptions to include the depth information
              • How to show top and base levels in the 'level' column.
              • How To use Text Styling to Make part of the Geology Description Bold
              • Is there a common list of requested Expressions available?
              • Log Only Functions
              • Mathematical Functions
              • My Expression in Template Studio shows the wrong date
              • Run Time Functions
              • Text Styling
              • Why do the numbered remarks in my data not appear on new lines on my templates?
            • +Loading and Saving Templates
          • +HoleBASE Template Studio:How Tos
          • +HoleBASE Template Studio:Issues
          • HoleBASE Template Studio Release Notes
        • +KeyAGS
        • +KeyLAB
        • +Keynetix Component Downloads
        • +Working from Home with Keynetix Products
        • Hardware Specifications and Recommendations
        • Supported Platforms

     
     Questions about this article, topic, or product? Click here. 

    Mathematical Functions

    Function

    Description

    Example

    Abs       

    Returns the absolute value of a specified number.

    Abs(-1)

    Acos

    Returns the angle whose cosine is the specified number.

    Acos(1)

    Asin

    Returns the angle whose sine is the specified number.

    Asin(0)

    Atan

    Returns the angle whose tangent is the specified number.

    Atan(0)

    Ceiling

    Returns the smallest integer greater than or equal to the specified number.

    Ceiling(1.5)

    Cos

    Returns the cosine of the specified angle.

    Cos(0)

    Exp

    Returns e raised to the specified power.

    Exp(0)

    Floor

    Returns the largest integer less than or equal to the specified number.

    Floor(1.5)

    IEEERemainder

    Returns the remainder resulting from the division of a specified number by another specified number.

    IEEERemainder(3, 2)

    Log        

    Returns the logarithm of a specified number.

    Log(1, 10)

    Log10   

    Returns the base 10 logarithm of a specified number.

    Log10(1)

    Max      

    Returns the larger of two specified numbers.

    Max(1, 2)

    Min       

    Returns the smaller of two numbers.

    Min(1, 2)

    Pow      

    Returns a specified number raised to the specified power.

    Pow(3, 2)

    Round  

    Rounds a value to the nearest integer or specified number of decimal places. The mid number behaviour can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object.

    Round(3.222, 2)

    Sign       

    Returns a value indicating the sign of a number.

    Sign(-10)

    Sin         

    Returns the sine of the specified angle.

    Sin(0)

    Sqrt       

    Returns the square root of a specified number.

    Sqrt(4)

    Tan        

    Returns the tangent of the specified angle.

    Tan(0)

    Truncate

    Calculates the integral part of a number.

    Truncate(1.7)

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Fri, Jun 26 2020 4:50 AM
    • Revisions: 1
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies