Multiple dependent Formula Cell
Closed this issue · 1 comments
mesutgungor commented
Hi is it possible to add a data-formula which depends on another data-formula ?
for example i have a snippet given in the same order.
<td><input id="C0" data-format="0[.]00000" class="C0" data-formula="$A0*(2^($B0/53))" value="$A0*(2^($B0/53))" type="text"></td>
<td><input id="D0" data-formula="1200*$C0/$C1" value="1200*$C0/$C1" type="text"></td>
<td><input id="C1" data-format="0[.]00000" class="C1" data-formula="$A1*(2^($B1/53))" value="$A1*(2^($B1/53))" type="text"></td>
<td><input id="D1" data-formula="1200*$C1/$C2" value="1200*$C1/$C2" type="text"></td>
ikhsan017 commented
Hi @mesutgungor
I am a bit unclear about your question, but this is how it works
<input id="A1" value="100">
<input id="B1" data-formula="$A1*2"> <!-- this will be 200 -->
<input id="C1" data-formula="$B1+100"> <!-- this will be 300 -->
<input id="D1" data-formula="$C1+$B1"> <!-- this will be 500 -->
a cell with formula will search the dependence and calculate the dependence first before calculating itself