IF > then return...

[Gary F Shelton]

Need some help writing a formula

Column A Column B Column C Column D Result
Return
500 652 450 710
710
850 200 50 354
850
620 892 100 400
892

My goal is to write a formula that will return the larges volume within
Column A thr D. As you can see the largest volume can be in any column/row
intersection.

Regards,
GFS

 

[Mike H]

Hi,

If you want it row by row put this in E1 and drag down

=MAX(A11)

If you want the maxh of the entire array in one formula use this

=MAX(A13)

Mike

 

[Duke Carey]

maybe:

=max(A11)

 

[Don Guillett]

Have a look in the help index for MAX