today I'm thinking about the "don't use floating point for money" advice I hear all the time. It obviously has a lot of truth to it.

But -- Excel/Google Sheets uses floating point for all of its calculations, people use spreadsheets for money calculations all the time, and it generally seems to work just fine -- the results get rounded for display.

So I'm trying to figure out if there's a more nuanced guideline than "never use floating point for money".

@b0rk It doesn't specifically state "Excel" but VBA's currency type is a fixed point 64 bit integer. Maybe if you specify "currency" as the column it uses this math?

https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/currency-data-type

Currency data type

Office VBA reference topic

@chadgeidel @b0rk

If you have the cell set as the accounting or currency vba scripts by reading from a sheet do get the 64bit fixed point currency type