Is any if the functions considered as volatile functions? (or will they slow down the performance?)

Regular Contributor



I am debugging a workbook to investigate why it is so slow. 


In many rows I find this formula:




Best regards

- Geir

2 Replies
best response confirmed by Geir Hogstad (Regular Contributor)

@Geir Hogstad 

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.