Formula calculation for a column in a form for specific number of rows
We are building a form and it has have many number of rows and columns. But our requirement is to create a formula in a column to find difference between 2 other column cell values.
For eg: we have around 300 rows and columns A, B and C. C is a formula column here and need to populate the difference between values in rows cells 100 to 200 from column A and column B.
The formula [B]-[C] in column C returns difference value from column A and column B cells for each row in the form, which we do not want it.