Calculation and Display

0
The formula is Z = A + B1 + B2 + (C1*C2*...).   What I am currently doing now is that to allow the formula to calculate the empty value. For example; If I indicate all the respective values except for Value A, the calculation using whatever values that has been added should provide the Value for A. So on for Value Z, Value B1 and Value B2.   However, currently, my method only works for Value A and Z.    Please assist me with this! Thank you!  
asked
1 answers
0

Use conditional logic to find the missing values dynamically (A, Z, B1, or B2). Rearrange the formula accordingly.

The formula must adapt based on which variable is null.

Implement this by checking each variable's null status and calculating it using the known values.

For example,

  • if B1 is null, compute it as B1=Z−A−B2−(C1∗C2∗...)
  • if Z is null, use Z=A+B1+B2+(C1∗C2∗…)
answered