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 Well, if every number you're feeding in is already fixed to 1cent resolution, and you're not doing many division ops on the values, there's nothing to worry about. If you're doing chained division ops, that's pretty weird, for money.