I would like to assign a cell a formula returning a calculation involving another cell value, and leaving the cell empty if the computation is not possible (e.g. if the other cell is empty / not a number / error).
Is this possible ??
I have tried a lot of things with Excel primitives but it seems like some of them are not recognized by Handsontable (return #NAME? error), and the other attempts keep returning #VALUE! error.
Here is an example with many of the formulas I have tried : http://jsfiddle.net/259dkjxv
Thanks in advance for your help.