Forum Discussion
Solved
Is any if the functions considered as volatile functions? (or will they slow down the performance?)
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
No, 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.
No, 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.
- Great, thank you.
