25 Replies Latest reply: Mar 20, 2012 11:33 AM by MikeArmstrong RSS

    Replace negative numbers in a Column Matrix with a different number.

    ptc-4451268 Bronze

      Hello,

       

      I have a column of data.

       

      If the column of data has a negative number, I would like to replace that number with a very small positive number, 10^-5.

       

      I've attached my worksheet explaining what I want to do.

       

      Any advice?

       

      Thanks!