Dec 09 2022 05:24 AM
Hi,
I am debugging a workbook to investigate why it is so slow.
In many rows I find this formula:
INT(YEARFRAC(RIGHT(E276;8);C276))
Best regards
- Geir
Dec 09 2022 05:42 AM
SolutionNo, none of those is volatile. The volatile Excel functions are:
RAND(), NOW(), TODAY(), OFFSET(), CELL(), INDIRECT(), INFO(), RANDBETWEEN(), RANDARRAY(), and in some situations (but usually not) SUMIF.
Dec 09 2022 03:26 PM
Dec 09 2022 05:42 AM
SolutionNo, none of those is volatile. The volatile Excel functions are:
RAND(), NOW(), TODAY(), OFFSET(), CELL(), INDIRECT(), INFO(), RANDBETWEEN(), RANDARRAY(), and in some situations (but usually not) SUMIF.