Table of Contents
The DOLLARFR function in Google Sheets is a built-in formula that allows users to convert a decimal number into a fraction format. This function takes in two arguments: the decimal number to be converted and the desired denominator (default is 32). It then returns the fraction representation of the decimal number, taking into account the specified denominator. This function is useful for creating more visually appealing data displays or for simplifying calculations involving fractions. By understanding how to use the DOLLARFR function, users can efficiently convert decimal numbers to fractions in their Google Sheets documents.
DOLLARFR
Converts a price quotation given as a decimal value into a decimal fraction.
Sample Usage
DOLLARFR(100.125,32)
DOLLARFR(A2,8)
Syntax
DOLLARFR(decimal_price, unit)
decimal_price– The price quotation given as a decimal value..unit– The units of the desired fraction, e.g.8for 1/8ths or32for 1/32nds.
Notes
DOLLARFRis used to convert from decimal format to prices specified on certain securities exchanges with minimal increments (e.g. 1/8 or 1/32). These prices may be transmitted on electronic exchanges as 100.01 for 100 1/8 or 100 1/32 depending on the system and minimal increment.DOLLARFR(100.125,8)results in100.01whereasDOLLARDE(100.03125,32)also results in100.01.
See Also
DOLLARDE: Converts a price quotation given as a decimal fraction into a decimal value.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdFVPVmYxWmEyZy1BNVpnU0d1VGY0VlE&output=html” width=”500″]
Cite this article
stats writer (2024). How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-dollarfr-function-in-google-sheets-to-convert-a-decimal-number-to-a-fraction/
stats writer. "How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-dollarfr-function-in-google-sheets-to-convert-a-decimal-number-to-a-fraction/.
stats writer. "How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-dollarfr-function-in-google-sheets-to-convert-a-decimal-number-to-a-fraction/.
stats writer (2024) 'How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-dollarfr-function-in-google-sheets-to-convert-a-decimal-number-to-a-fraction/.
[1] stats writer, "How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the DOLLARFR function in Google Sheets to convert a decimal number to a fraction?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.