shg,
The OP is using a non US version of Excel so your formula is evaluating to (changing regional settings to US):
=123 - FLOOR(123-1.9) or =123 - FLOOR(121.1). Because his decimal separator is a comma, not a period the FLOOR function has only one argument..