User Manual

10.03.2024

MANUAL

Formula (Extended): $ROUNDUP Function

## Overview Return the value of a numerical value rounded up to the specified number of digits. ## Syntax ``` $ROUNDUP(Numerical value, Number of digits) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Numerical value|Half-width numerical value|Required|Numerical value to round up. | |Number of digits|Half-width numerical value|Required|Number of digits to round up to. | ### Column available for parameters |Parameter|Category|Number|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Numerical value|Yes|Yes|No|Yes|No| |Number of digits|Yes|Yes|No|Yes|No| ## Return Value The numerical value is rounded up to the specified number of digits. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. If the drop-down list has values, the options that match the values ​​are displayed. | |Numerical Value (including work volume, progression rate, remaining work volume)|Display return value. | |Date (including start and completion)|Do not display. | |Description (including content)|Display return value. | |Check (including lock)|Do not display. | ## Usage Example ① Specify parameters by screen column name (name displayed) ### Formula ![image](https://pleasanter.org/binaries/befa477a988646ed9d1dc82f9827501b) ### Parameters ![image](https://pleasanter.org/binaries/2624849f9070475e841a9779cbe212cb) ### Calculation Result ![image](https://pleasanter.org/binaries/3bebd2be08d24f1f8e7988e118b6f5cb) ## Usage Example ② Truncate to one decimal place ### Formula ![image](https://pleasanter.org/binaries/c071708e6ece48ea8e5cbd53f5cabcaf) ### Parameters ![image](https://pleasanter.org/binaries/2df618f1493e475d8b7bf38ce0b46440) ### Calculation Result ![image](https://pleasanter.org/binaries/9edb67b4a29547adb5de8f84f82855d6)
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.