Locking formulas

[Lenny]

Say for instance I have a formula in cells A2 through A10. The formula is
dependent on a value entered from a drop down list in cell J3, which could
vary for each entry, A2 through A10. Is there a way to keep the formula in
Cell A2 from recalculating when I enter data for cells A3 through A10?

 

[Frank Kabel]

Hi
you may post your formula and your expected results?

--
Regards
Frank Kabel
Frankfurt, Germany

Say for instance I have a formula in cells A2 through A10. The formula is
dependent on a value entered from a drop down list in cell J3, which could
vary for each entry, A2 through A10. Is there a way to keep the formula in
Cell A2 from recalculating when I enter data for cells A3 through

A10?

 

[Lenny]

The formula in cells C1:C10 is =IF(J$3=T$8, "050", IF(J$3=T$9, 510, ""))

My problem is that if the value for J3 is different in cell C10 than it is
in cell C1, the result in C1 changes. What I'd like to do is somehow lock or
freeze the results in cell C1 so that when I enter the data cells C2:C10 it
doesn't change.