Formula to KNIME

[charabor1]

=IF(OR(F32=“100003000”,F32=“105001000”),TRIM(F32&“-”&LEFT(P32,10)),IF(OR(F32=“115001100”,F32=“230004600”),TRIM(F32&“-”&I32&“-”&M32),IF(OR(F32=“115002000”,F32=“199010000”,F32=“199012100”,F32=“199013000”,F32=“199013080”,F32=“230004800”,F32=“270001000”,F32=“270006310”,F32=“270007100”,F32=“299001000”,F32=“115004300”,F32=“115001300”,F32=“230001200”,F32=“500011200”,F32=“720000700”,F32=“720000900”),TRIM(F32&“-”&I32),TRIM(F32))))

=IF(OR(F32=$F$2,F32=$F$3,F32=$F$4,F32=$F$5),“T”,IF((V32=“950074100”),“N/A”,LEFT(F32,1)))

IF(
OR(
$F32$ = “100003000”,
$F32$ = “105001000”
),
TRIM($F32$ & “-” & LEFT($P32$, 10)),
IF(
OR(
$F32$ = “115001100”,
$F32$ = “230004600”
),
TRIM($F32$ & “-” & $I32$ & “-” & $M32$),
IF(
OR(
$F32$ = “115002000”,
$F32$ = “199010000”,
$F32$ = “199012100”,
$F32$ = “199013000”,
$F32$ = “199013080”,
$F32$ = “230004800”,
$F32$ = “270001000”,
$F32$ = “270006310”,
$F32$ = “270007100”,
$F32$ = “299001000”,
$F32$ = “115004300”,
$F32$ = “115001300”,
$F32$ = “230001200”,
$F32$ = “500011200”,
$F32$ = “720000700”,
$F32$ = “720000900”
),
TRIM($F32$ & “-” & $I32$),
TRIM($F32$)
)
)
)

IF(
OR(
$F32$ = $F$2,
$F32$ = $F$3,
$F32$ = $F$4,
$F32$ = $F$5
),
“T”,
IF(
$V32$ = “950074100”,
“N/A”,
LEFT($F32$, 1)
)
)

[HansS]

Hi @charabor1

I think this is Excel and the outcome is 42.

How to Best Ask For Help on the Forum

How to Best Ask for Help Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: How can you write a post that is most likely to get the help you need? You might think that logically, a good title for your post would be “Help with an error”, right? Well… not exactly. Put yourself …

gr. Hans

[lelloba]

@HansS But we should have waited another 7.5 million years to get this answer

@charabor1 give us some more details to understand the issue, we can’t know what this formula does, if it’s correct and what data it is handling. always remember to give a little context, state the problem/objective and provide some data/workflow when you are ready, we are here

Have a nice evening,
Raffaello Barri

[mlauber71]

@charabor1 just for the fun of it I let ChatGPT figure this one out and come up with a working yet maybe un-managable Java Snippet Code and also create some sample data by guessing … enjoy

Java Snippet - Convert Excel Formula - KNIME Forum (78011) – mlauber71

edit: to give this a more helpful touch. @charabor1 maybe you want to take a look at a similar problem and the use of Column Expressions:

A newbie question about Rule Engine

@alicemello you can use a Java Snippet or a Column Expression node to have if, then, else conditions. Your example adapted to the Column Expression node would look like this: [image] if (column("Age") >= 18 && column("Age") <= 30 && column("AST") >= 150 && column("AST") <= 250 && column("3P") >= 90 && column("3P") <= 150 && column("PTS") >= 800 && column("PTS") <= 1400 && column("TOV") >= 80 && column("TOV") <= 180) { "G"; } else if (column("Age") >= 18 && column("Age…

[danielsidata]

Just paste the formula in this workflow then voila

Inserting and Calculating Formula in Excel (includes Financial Formula, Array Formula, etc.)

Continuing my series on Spreadsheet Automation, this time I’ll show you how to insert and calculate Excel Formula into your spreadsheet, so it would be easy for you to automate your spreadsheet by simply copying the formula into this KNIME workflow. Full Walkthrough will be available later Spreadsheet Automation - Creating Excel Pivot Tables