DOLLARDE

Definition: DOLLARDE is a function that converts a decimal number to text with a currency format based on a specified fraction.

Syntax: =DOLLARDE(fractional_value, [decimals])

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

Example: If you have a decimal value of 0.875 and want to format it as a currency value based on a fraction of 32, the formula =DOLLARDE(0.875, 32) can be used, which returns “$27.50”.