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.
