rounding_fun

Please note:

  • Cell E5: =ROUND(B5 * 2,0) / 2 is better than =ROUND(B5 / 5,1) * 5 because the internal binary representation of floating point numbers is more accurate for multiplikations and for divisions.
  • Cell C9: This result is the maximal number in T-Note format which is less or equal to the input in cell B9.

Download

Please read my Disclaimer.

rounding_fun.xlsm [33 KB Excel file, open and use at your own risk]