Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
RangeMin(A,B,C)
RangeMin(A,B,C)
or RangeMin(A,B) as C
Load *,If(A<B, A,B) as C Inline
[
A, B
10,12
20,15
5,2
];
hi
also try this
if(A<B,A,if(B<A,B))