Form Response ARRAYFORMULA?

I have created a form to record measurements, and I need to calculate the average and percent difference between the average and the actual weight measured. I believe I should be using an =ARRAYFORMULA. The formulas I used were =ArrayFormula(AVERAGE(D1:F1)) for average and =ARRAYFORMULA((G1-1)/1) for the percent difference.

Screen Shot 2023-03-12 at 1.56.02 PM.png

I'm not familiar with setting up =ARRAYFORMULA. Any help is appreciated!

Both formulas worked in for 1 mg measurements, but I'm having a hard time getting the percent difference to work for 200 mg measurements.

I'm using this formula: =ARRAYFORMULA(IF(LEN(L1:L),L1:L-200/200,))

Attachment 821466

Can you share a file with some sample data with expected results.

Here's some sample data:

example data.xlsx

See if this sheet has the figures you're looking for.

Not exactly. I'm having the same issue where the results for % Diff are not correct. For column K, the responses should be : 0.333333334 (K2), -0.108333334 (K3), and -0.008333334 (K4). For Column P, the responses should be: 0.366666667 (P2), -0.15 (P3), and 0 (P4).

But, you helped me figure it out! The formula was a little off. This is what ended up working: =ARRAYFORMULA(IF(L:L,(L:L-200)/200,))

Thank you for all your help!!

I'll add that my final formula was =ARRAYFORMULA(IFERROR((L:L-200)/200,"% Diff"))