- Picture and text skills
- Case
DOLLARDE function
Converts a price expressed as an integer part and a fractional part (for example, 1.02) to a price expressed as a decimal part. Fractional dollar figures are sometimes used to express security prices.
The fractional part of the value is divided by A specified integer. For example, if you want to express a price in hexadecimal form, divide the fractional part by 16. In this case, 1.02 means $1.125 ($1 + 2/16 = $1.125).
Syntax
DOLLARDE(fractional_dollar, fraction)
DOLLARDE function syntax has the following parameters:
Fractional_dollar Required. A number expressed as an integer part and a fractional part, separated by a decimal point.
Fraction Required. A whole number used as the denominator in a fraction.
Remarks
If fraction is not an integer, it will be truncated.
If the fraction is less than 0, DOLLARDE returns the #NUM! error value.
If the fraction is greater than or equal to 0 and less than 1, DOLLARDE returns the #DIV/0! error value.
Example
| Formula | Description | Results |
|---|---|---|
| =DOLLARDE(1.02,16) | Converts the fractional price 1.02 (pronounced one and two sixteenths) to a decimal price (1.125). Since the fractional value is 16, the price is in hexadecimal. | 1.125 |
| =DOLLARDE(1.1,32) | Convert the fractional price of 1.1 (pronounced one and thirty 10/2) is converted to a decimal price (1.3125). Since the fraction value is 32, the price is in hexadecimal notation. | 1.3125 |
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/biao-ge-cai-wu-han-shu-DOLLARDE-han-shu.html
支付宝扫一扫 
评论列表（196条）
测试