DOLLARFR

Definition: DOLLARFR is a function that converts a fractional value to text with a currency format based on a specified fraction.

Syntax: =DOLLARFR(fraction, [decimals])

Situation: This formula is suitable when you need to convert a fractional value to text with a currency format based on a specified fraction.

Example: If you have a fractional value of 27/32 and want to format it as a currency value based on a fraction of 32, the formula =DOLLARFR(“27/32”, 32) can be used, which returns “$27.84”.