Expand my Community achievements bar.

Formcalc if formula

Avatar

Former Community Member

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

1 Reply

Avatar

Former Community Member

one more note: my fields are not in a table.