Functions
DOLLARDE
Convert dollar price to decimal
Try it
When to use it
When should I use DOLLARDE?
Use DOLLARDE to convert a bond price quoted in fractional notation (e.g., 100.10 meaning 100 and 10/32) to a plain decimal price that can be used in arithmetic.
Used in
Syntax
DOLLARDE(fractional_dollar, fraction)Examples
=DOLLARDE(100.10,32) // => 100.31249999999999
=DOLLARDE(100.01,8) // => 100.0125