8 Replies Latest reply: Mar 7, 2016 7:21 AM by Azam Mullick RSS

    Calculation error

    Hasvine Dhurmea

      Hello All,

       

      I have to calculate the INDICE as per the attached spreadsheet.

      The formula is

       

      =-(1-(TMT Pondéré/TMT Cible Pondéré)

       

      However I need only the total to be calculated.

       

      Any idea?

       

      I tried different ways but I cannot find the solution.(even using variable)

       

      I copied the expression i've used for all calculation in the first row.

       

      Many Thanks,

       

      Hasvine