Differences in Microsoft Excel Functions by Run Mode

The Extreme Speed feature in Crystal Ball uses a proprietary spreadsheet interpreter to increase calculation speed. This interpreter calculates Microsoft Excel functions independently of how they are calculated in Normal speed using the native Microsoft Excel calculation code. For this reason, some functions may generate slightly different results in Extreme and Normal speed.

Functions that might have different results are XIRR, XNPV, IRR, PMT, CUMIPMT, and CUMPRINC.