MAX function

[jacobsenm]

Hi,

how would I write a MAX function across fields in a record.

EG:

Name A B C
John 1 4 2
Tom 3 12 17

So I want to return
John 4
Tom 17

I've tried the following but it does not seem to work.

=MAX(In(A,B,C)

Cheers
Mark

 

[Norie]

Mark

Have you not looked at the replies to your original post?

 

[jacobsenm]

Yes, but I didn't really understand.

I wanted to know if my new suggestion would work.

I'll try to get someone to explain the code to me.

Thanks
Mark