If you want to add a new column with a formula, use a column expressions node, a math formula node or a string manipulation node, just to mention some of the main ones.

I input a formula into cell A1 of the table creator eg =(A1+B1)

I have created a workflow whereby that specific formula gets placed into a specific cell of my output spreadsheet. I use the excel updater node to achieve this.

However that output still displays as the actual formula instead of the calculation for A1+B1.

I would like my output to display the actual calculation instead of the formula.

Hi @jasonk2022 , this is simply not how KNIME works. Calculations are performed by nodes such as the Math Formula node in the workflow to create the columns based on calculations, or to perform transformations on your data. â€ťcells" are not referenced in the way you might reference them in Excel . You need to think in terms of columns rather than single cells.

KNIME is a powerful tool but you need to think differently to the way you do something in Excel. Where have you read that you can enter a formula in a cell in this way?

I would suggest that you take a look at some of the basic tutorials to get a feel for how KNIME works. But if you have some sample data and you can show us what end result you want from it, somebody may be able to give you some advice for how this is done.

There are some â€ścommunity nodesâ€ť which you can install which may help do some of what you are looking for. For example take a look at the AF nodes - a very useful set of utility nodes by @AnotherFraudUser

This one caught my eye in relation to your question:

I hadnâ€™t previously tried it, but given the following input:

it generated this:

Combined with a column filter to then remove the original formula, and this could be of interest. I would still however recommend learning the actual KNIME nodes way of doing things, but if you really are needing to hand-craft individual cells with different calculations, then this is (maybe) a possible way of achieving it. But keep in mind that there will be limitations to working in this way, and limits you really to working with quite static data.