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 [object Object]
excel match [object Object]
lattice match 1.5
ironcalc match 1.5
hyperformula match 1.5
libreoffice diverge
formulas match 1.5
pycel match 1.5