Minimum of two fields

[#1]

Hi All,

I have two fields like below. I would like to see the minimum value of those two fields in third field with our uisng IF condition.

A     B     C

10     12     10    

20     15     15

5       2       2

Thanks in advance.

[MK_QSL · Accepted solution]

RangeMin(A,B,C)

[MK_QSL]

or RangeMin(A,B) as C

[MK_QSL]

Load *,If(A<B, A,B) as C Inline

[

     A, B

     10,12

     20,15

     5,2

];

[#5]

hi

also try this

if(A<B,A,if(B<A,B))