View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
PSU35
 
Posts: n/a
Default 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