IAI CP2

IAI Subject CP2 — Modelling Practice (Institute of Actuaries of India)

Model TestingEnglish
Exam overview

Practice session

An actuary notices that a balance sheet check `=Asset_Total - Liability_Total` evaluates to `0.000000000000142` instead of exactly `0.00`, causing an exact equality test `=(Asset_Total = Liability_Total)` to return `FALSE`. What is the best spreadsheet engineering practice to handle this?

Loading your practice session…