Max function

[AmCh]

hello all,

I am trying to calculate the maximum value from three fields and feed the determined value into a new field using for loop.

As an example for the input fields would be:

A,B&C (with the same size)

Ouput would be:

D ( row i is equal to the maximum value of rows i of A,B &C).

Thanks in advance

[sergio0592 · Accepted solution]

Hi,

Try with

=rangemax(A,B,C)