G Guest Oct 25, 2003 #1 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
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 Oct 25, 2003 #2 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)
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)
