Summing & return highest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Cell A1 may have a number entered.
Cells A2 thru A13 may have numbers entered.
I want cell A14 to display which ever has the higher value.... A1 or the sum
of cell range A2:A13.

What would be the formula? Please no VBA or macro's
 
Try this:

A14: =MAX(A1,SUM(A2:A13))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Back
Top