Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

A spreadsheet would have prevented the author from using floating point to represent money.


For the purposes of my example assignment, I am required to provide all answers rounded to the nearest dollar (hence the call to round().) For a one-off (or ten-off) series of calculations the use of floating point is a non-issue.


What is the issue with using floating point to represent money?


  Time spent writing obvious reply:        $2.50
  Good faith deduction:                   ($1.00)
  Deduction for joke comment opportunity: ($1.50)

  Dear jbl, your invoice total is $0.00000027.


Ah. Right. Rounding errors and other floating point issues. Guess I should have my coffee before reading HN. headdesk


get out.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: