1 Reply Latest reply on Jan 4, 2015 12:31 AM by Fuel Expenses Form

    Formcalc if formula

    Fuel Expenses Form

      Dear all

      i'am new to formcalc, but making effort to use it.

      i had a problem with the last formula in the form, which is:


      i have two sets of numeric fields


      (A1, A2, A3, A4, A5) let us call it Group A


      (B1, B2, B3, B4, B5) let us call it Group B


      The result field "X" should show B cell value against maximum value of A cells


      example: if A3 is max then X =B3

                    if A5 is max then X =B5

       

      Please if anyone can help