Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating and locking the esult of a formula
I am creating a worksheet where fields are updated dynamically using a dde,
once the result of a formula is calculated it brings about a certain condition in one other part of the sheet example: IF(AI91="LONG","L",IF(AJ91="SHORT","S","")) Since the fields that this formula observes are dynamically updated the condition might change, but since I am only interested in the first occurance i wanted to lock the result of the first time a calculation is done, is it possibile? |
#2
|
|||
|
|||
Hi
not possible with a formula. this would require an event procedure -- Regards Frank Kabel Frankfurt, Germany "investor" schrieb im Newsbeitrag ... I am creating a worksheet where fields are updated dynamically using a dde, once the result of a formula is calculated it brings about a certain condition in one other part of the sheet example: IF(AI91="LONG","L",IF(AJ91="SHORT","S","")) Since the fields that this formula observes are dynamically updated the condition might change, but since I am only interested in the first occurance i wanted to lock the result of the first time a calculation is done, is it possibile? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|