View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sony654 sony654 is offline
external usenet poster
 
Posts: 22
Default 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