[SOLVED] Summing & return highest value

[PSU35]

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

[Ron Coderre]

Try this:

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

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

XL2002, WinXP


"PSU35" wrote:

> 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

[PSU35]

Thanks much...works great.

"Ron Coderre" wrote:

> Try this:
>
> A14: =MAX(A1,SUM(A2:A13))
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "PSU35" wrote:
>
> > 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