Display Last Value Calculated in Formula Range
 

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
--
Sony Luvy

Display Last Value Calculated in Formula Range
 

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(D90:D93),LOOKUP(99^99,D90:D93),"-")

Biff

"sony654" wrote in message
...
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
--
Sony Luvy