How do I create a “square” with fields that can that input an amount on one side and show a result on the other. The same concept having 4 Excel cells (2 and the top and bottom) and having the left side input the right side show a total.
Atleast 100 - This is for the Number entry at the top.
Side 1 (Top Left) - This is for the top left value of the data grid
Side 2 (Bottom Left) - This is for the bottom left value of the data grid.
There are then 3 Math Colums:
First Calculation would be: Alteast 100 - Side 1 (Top Left)
You would have this as Side 2 (Top Right) in the data grid.
Second Calculation would be: First Calculation + Side 2 (Bottom Left)
This wouldnt need to be displayed anywhere based on your example, its just needed for the next calculation.
Third Calculation would be to get the remaining amount: Atleast 100 - Second Calculation.
This would be displayed bottom right in the data grid.
Based on this, if you’re wanting the 95 Displayed in the bottom left instead of the 35, you would need another number entry (Same as the Atleast 100 one) to input the 35… Then the bottom left of the 2nd data grid would be the Calculation of the 35 plus the Top right.