| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping a formula once a condition has been met.
Cell A1 of my worksheet contains the following formula:
='[WTA Work History Overall.xlsx]Retirement Summary'!Retirement_Payment Cell A2 contains a date. Is there any way that the formula in cell A1 can be constructed so that once the date exceeds the date in cell A2 that the formula stops updating the value in cell A1 and just shows the value that was in place prior to exceeding the date in A2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looping and stopping when a condition is met - test | Excel Discussion (Misc queries) | |||
| Stopping a formula | Excel Discussion (Misc queries) | |||
| MORE THAN ONE CONDITION IN A FORMULA | Excel Worksheet Functions | |||
| Formula For If & Or Condition | Excel Discussion (Misc queries) | |||
| If formula and #N/A as a condition | Excel Discussion (Misc queries) | |||
![ordnance1[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
