SOLVED

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

Steel Contributor

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

2 Replies
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@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.

1 best response

Accepted Solutions
best response confirmed by Geir Hogstad (Steel Contributor)
Solution

@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.

View solution in original post