i have successfully implemented the formula in demo but here is thing i am using redux to store data of table since i want to use it somewhere else for calculations but i realize that when i use formula like “=TRUNC(C1*(1+D14/100),2)” while providing initial data ,i can see the required value but when i try to get it from state i get this “=TRUNC(C1*(1+D14/100),2)” formula instead of value.
If we could look at the code it would be simpler.
So, please use this demo https://jsfiddle.net/u7t8cLn3/
and change it to suit your application.
i want to get the updated values from state of table
this is the demo code
your’re looking for the