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
one more note: my fields are not in a table.