Conditional formula help

[Dom523647]

Hello,

I can't figure our correct formula for this problem:
The primary key has multiple costs, that are displayed in columns "Item1, Item2 and etc."
I want to assign VAR that multiplies primary key sales amount with either Item1, Item2 cost
The condition should check each Item column and pick only the lowest cost, else bring is blank()

I'm attaching the example table below.

I would appreciate any comments or help!

 

[arthurbr]

What dose VAR mean?

 

[Dom523647]

@arthurbr Variable

 

[Dom523647]

@arthurbr I was thinking to use something similar to the MIN function, that selects a scalar value, but instead of aggregating one column, it scans between columns.