Max function

AmCh — Fri, 15 Nov 2024 23:19:42 GMT

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

Re: Max function

sergio0592 — Wed, 13 Jan 2021 15:07:11 GMT

Hi,

Try with

=rangemax(A,B,C)