Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do I set things up so that a custom function automatically recalculates
when a cell value changes? I have function which calculates a value based on several cells and need the value updated when the cells change. In the example below, I need the value in cell A1 to update when the value of B1, C1 or D1 changes. Column Row A B C D =getDescription() Y N Y getDescription looks at the values in the cells and returns a string based on the values found. Should I be passing the values directly into the function as in =getDescription(B1, C1, D1) David H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numerical integration | Excel Discussion (Misc queries) | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Custom function to simplify Index(match)) formula | Excel Discussion (Misc queries) | |||
Custom Function | Excel Discussion (Misc queries) | |||
Custom function returning VALUE error | Excel Discussion (Misc queries) |