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