assay
math

floor-fractional

Subject
FLOOR
Category
value
Formula
=FLOOR(1.58, 0.1)
Canonical
1.5

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match 1.5
excel match 1.5
lattice match 1.5
ironcalc match 1.5
hyperformula match 1.5
libreoffice diverge
formulas match 1.5
pycel match 1.5