ExcelBanter - Summing & return highest value

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Summing & return highest value (https://www.excelbanter.com/new-users-excel/91474-summing-return-highest-value.html)

PSU35

Summing & return highest value

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

Summing & return highest value

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

Summing & return highest value

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

All times are GMT +1. The time now is 08:11 PM.