assay
statistical-distributions

lognorm-inv-roundtrip

Subject
LOGNORM.INV
Category
value
Formula
=LOGNORM.INV(LOGNORM.DIST(2, 0, 1, TRUE), 0, 1)
Canonical

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets diverge 2.00000
excel diverge 2.00000
lattice diverge 2
ironcalc diverge 2
hyperformula diverge #NAME?
libreoffice match
formulas diverge 2
pycel diverge #NAME?