An excel formula for reading from a volatile function?

Question

I have a volatile function, say =getprice()in a cell A1, that can succeed by returning a price or failing by returning #REF!. Is there a way to write a formula in B1that is read from A1, if it is successful, get the value, and if you could not save the value of the last round?

Answer 1

If you enable Enable iterative calculation with maximum iterations set to 1, then:

=IF(ISERROR(A1),B1,A1)

Answer 2

I understand that this is a late answer, but here is another alternative that doesn’t exactly answer your question, but still I think this is useful information:

, , . , , , .

B1 :

, A1 , , "" A1, B1, B1 , .

, , cell B1 , :

• Excel (-, ).

• .

. , A1 volatile = NOW(), , B1, , NOW() , B1 A1, , B1 .