Summing
Rick wrote:
I made a typo below which changed the description of what I am
trying to do. A14 needs the highest value from either A1 or the
sum of A2:A13
I am glad you clarified that. Your first posting made no sense to me.
Try:
=if(isblank(A1), "", max(A1, sum(A2:A13)))
|