IF then return...
 

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


--
GS

IF then return...
 

Hi,

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

=MAX(A1:D1)

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

=MAX(A1:D3)

Mike

"Gary F Shelton" wrote:

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


--
GS

IF then return...
 

maybe:

=max(A1:D1)



"Gary F Shelton" wrote:

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


--
GS

IF then return...
 

Have a look in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary F Shelton" wrote in message
...
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


--
GS