Help! Form fields in table and calculations!
Hi all, can someone change this formula-
=(SUM(C9,C17,C25,J9,J17,J25)-6*39+ABS(C9-39)+ABS(C17-39)+ABS(C25-39)+ABS(J9-39)+ABS(J17-39)+ABS(J25-39))/2
to read from the cells in table1?
The form has two tables with form fields in, the first is the input table,
the second is the output or results table. The above works well in a cell
in the input table, but will not work in the output table, it gives strange
results!
Many Thanks!
Steve
|