Calculating and locking the esult of a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
not possible with a formula. this would require an event procedure
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write the result of a formula only once then lock it 1
Formula, one field complex or multiple table field simple 1
Dynamic Sum Array Formula Input Help 3
Trailing 30 days sum calculation with excel 1
Scrabble Value calculation for Welsh words 0
Run numerous calculations through a single formula 1
Excel 2003 worksheet doesn't auto calculate 4
How to show all formulas of cells in cells (and not the calculated result) ? 10

Back
Top