The DOLLARFR function in Google Sheets is a useful tool for converting price quotations from decimal representation to fractional form. This function is particularly beneficial for financial professionals who work with fractional prices, such as in trading or investment scenarios.

Syntax

DOLLARFR(decimal, fraction) 

• decimal: The price quotation represented as a decimal value.
• fraction: The denominator of the fraction to convert the decimal into. For instance, a fraction of 8 indicates eighths.

Example #1

DOLLARFR(2.75, 8)

This function converts the decimal 2.75 into eighths, resulting in a value of 22. Result: 22

Example #2

DOLLARFR(4.5, 16)

Here, the decimal 4.5 is converted to sixteenths, yielding a value of 72. Result: 72

Example #3

DOLLARFR(1.125, 32)

This call transforms the decimal 1.125 into thirty-seconds, providing a final value of 36. Result: 36

Error handling

• VALUE! This error occurs if the ‘decimal’ parameter is not a numeric value. Ensure that the input is a valid decimal.
• NUM! This error is shown when the ‘fraction’ parameter is not a positive integer. Check that the fraction is a valid positive integer.

Conclusion

In summary, the DOLLARFR function is a valuable asset for anyone needing to work with fractional prices. By transforming decimal values into fractional equivalents, it facilitates clearer financial analysis and reporting. Understanding how to use DOLLARFR can greatly enhance the efficiency of financial calculations in Google Sheets.