Hello. I need to find a minimum values from 4 columns. I found this topic - Find minimum value in multiple column - but it is an example with 3 columns. I tried to edit variable for my case but it was not helpful. Here is my variable:
=If ([W]<[X]) Then (If ([W]<[Y]) Then [W] ElseIf ([Y]<[X]) Then [Y] ElseIf ([X]<[Y]) Then [X])
ElseIf([Y]<[Z]) Then [Y]
Else [Z]
And here is my table:
±----±----±----±----+
| W⠀| X⠀| Y⠀| Z⠀|
±----±----±----±----+
| 0.9 | 0.5 | 1 | 0.4 |
±----±----±----±----+
As you can see, minimum = 0.4. But with my variable it is 0.9.
Can anyone please tell me how to get minimum from 4 columns? And maybe from more columns. I don’t fully understand the principle of this variable. Maybe this topic will be helpful to others who will search this.