kevsh
asked on
Multiple operations within a form
I am creating a form with 13 fields. 2 of the fields are constants (field A and B), 4 of the fields need user input (fields C, D, E, J), and the remaining fields (fields F, G, H, I, K, L, and M )are formulas pulling the data from the 2 constant and 4 user inputted fields. I want to make it so the user enters the data for fields C, D, E, J, and by saving the form, the rest of the fields automaticlaly calculate. To elaborate on the formula fields:
F=A * E
G=F * B
H=D + F
I=H + G
K=1-(H/L)
L=I/(1-J)
M=C * L
How do I do this?
F=A * E
G=F * B
H=D + F
I=H + G
K=1-(H/L)
L=I/(1-J)
M=C * L
How do I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks