Table with form fields: cell formulas

M

Michael

I want to set up a cell in a table using field forms that will display the
difference between two nearby table cells. For example, I would like my
table to automatically display in E2 the result of the value entered in D2
minus the value entered in C2. Every cell in the table is set up using field
forms.
 
S

Suzanne S. Barnhill

Make E2 a calculated form field. Be sure to enable "Calculate on exit" in
the form fields in C2 and D2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top