Handsontable example

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/handsontable/8.2.0/handsontable.full.min.js"></script>
<div>
  <div id="example" class="hot handsontable htRowHeaders htColumnHeaders"></div>
</div>

CSS

</style><!-- Ugly Hack due to jsFiddle issue -->

<script src="https://cdn.jsdelivr.net/npm/handsontable@8.2.0/dist/handsontable.full.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdn.jsdelivr.net/npm/handsontable@8.2.0/dist/handsontable.full.min.css">

JavaScript

var data = [
    [null, '=IF(ISBLANK(A1), "", A1*UR)'],
    [null, '=IF(ISBLANK(A1), A1, A1*UR)'],
    [null, '=IF(ISEMPTY(A1), "", A1*UR)'],
    [null, '=IF(ISNUMBER(A1), A1*UR, "")'],
    [null, '=IF(A1<>"", A1*UR, "")'],
    [null, '=IF(ISERROR(A1); ""; A1*UR)'],
    [null, '=IFERROR(A1*UR; "")']
    
  ];
  var example = document.getElementById('example');
  
  var hot2 = new Handsontable(example, {
    data: data,
    colHeaders: true,
    rowHeaders: true,
    contextMenu: true,
    formulas: {
      variables: {
        UR: 10,
      }
    },
  });