0 Replies Latest reply on May 12, 2012 4:07 PM by orlandobv

    repeat the formulas in diferent fields

    orlandobv

      Have been trying to get some info in google, nothing useful. My problem is the following :

      I have an array similar a table, lets say  3 rows & 3 columns,  in each of field of colunm 3  i must Have the result of multiply first fields X second field (everithing in the same row). The formula is:

       

      field 3.1 = field 1.1 * field 2.1  thats is the result for the first row , for the second row will be  field 3.2 =  etc etc

       

      Here is the thing ; if I have more than 20 rows, I have to write the formula +20 times

       

      Then, how I repeat the same formula with the apropiate indexes in formCalc ????????????

      I am thinking about some similar to exel, if you pulldown  the handle for the first cell, exell repeat the formula with the indexes according the cell position

       

      Could be done something similar or formCalc use other method

       

       

      Please, HHHHHelp is greatly appreciatted

       

      Orlando