- Picture and text skills
- Case
Use DOLLARFR to convert a decimal to a fractional amount, such as a security price.
Grammar
DOLLARFR(decimal_dollar, fraction)
DOLLARFR function syntax has the following parameters:
▪Decimal_dollar Required. decimal.
▪Fraction Required. A whole number used as the denominator in a fraction.
Remarks
▪If fraction is not an integer, it will be truncated.
▪If fraction is less than 0, DOLLARFR returns the #NUM! error value.
▪If fraction is 0, DOLLARFR returns the error value #DIV/0!.
Example
Formula | Description | Results |
=DOLLARFR(1.125,16) | Converts the decimal number 1.125 to a fraction (pronounced one and two-sixteenths). | 1.02 |
=DOLLARFR(1.125,32) | Converts the decimal number 1.125 to a fraction (pronounced one and four thirty-two-quarters). | 1.04 |
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-DOLLARFR-han-shu.html
支付宝扫一扫 
评论列表（196条）
测试