| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a calculated cell range into an excel function | Excel Worksheet Functions | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
| Can "IF" function display calculated data as bold? | Excel Worksheet Functions | |||
| How do I apply the ROUNDUP formula to a range of calculated data | Excel Worksheet Functions | |||
Linear Mode
