Display Last Value Calculated in Formula Range

[Guest]

I would like to write a function that posts the the last value calculated in
a formula range. Cells d90:d93 post a calculation, or result in "-", if not
calculated. How do I write a function in cell d94 that posts the last
calculated value in cells d90:d93? For example if only cells d90 and d91
have values calculated, the value calculated in cell d91 will be posted in
cell d94. Thanks for your help. Sony

 

[T. Valko]

Cells d90:d93 post a calculation, or result in "-", if not calculated.

I'm assuming calculated means a number is the result.

Try this:

=IF(COUNT(D9093),LOOKUP(99^99,D9093),"-")

Biff