avoidance cell recalculation in certain situations

A

a.ekster

how to write a formula that make a cell to do calcuations only if certain conditions are met, otherwise to do nothing, i.e. to retain old value of the cell
 
J

J.E. McGimpsey

One way:

Choose Tools/Options/Calculation. Check the Iterations checkbox and
put 1 in the maximum iterations box. Click OK.

Say you want C1 to =A1*B1 if J1>5, otherwise retain its value:

C1: =IF(J1>5, A1*B1, C1)
 
Top