condition with 3 Fields

[zied_ahmed1]

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

[Anonymous]

if (Field1>Field2 and Field2>Field3,1,(if(field2>field1 and Field1>field3,2,(IF(Field3>Field2 and Field2>field1,3)))))??

[zied_ahmed1]

Just we Need 1>2 and 1>3 etc...

[Anonymous]

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