Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have 3 fields field1 field 2 and field3
I want when :
1/ field 1 > field 2 field3 i display 1
2/ Field2> Field 1 >Field3 I display 2
3/Field3> Field2 >Field1 I display 3
If we have just 2 Fields we will do : if (Field1>Field2,1,2)
Regards
if (Field1>Field2 and Field2>Field3,1,(if(field2>field1 and Field1>field3,2,(IF(Field3>Field2 and Field2>field1,3)))))??
Just we Need 1>2 and 1>3 etc...
Didnt get you Zied.
You can change the condition to
if (Field1>Field2 and Field1>Field3,1,(if(field2>field1 and field2>field3,2,(IF(Field3>Field2 and Field3>field1,3))))).
But both are same. Transtive property