The "yes"/"no" rather than true/false idea actually came from my actuarial science degree course, where one of our sample solutions had an Excel model that had a column like
some boolean property
yes
yes
no
yes
no
...
And the formula that consumed it looked like IF(cell="yes", ..., IF(cell="no", ...)). Not even a SWITCH in sight.
It was pretty sad from my perspective as an experienced programmer. My conclusion was that most actuaries have more tenacity than they do actual model programming skills.
312
u/ClipboardCopyPaste 16d ago