Forum Discussion
How to write a formula to choose the greatest value
I am needing help with a formula, where it chooses the highest value of 2 numbers and then adds that number to a list of numbers.
5,7, and it would chose the 7 to add to the sum of other numbers
1 Reply
Let's say the two values you want to take the highest of are in A1 and A2, and the other values are in A3:A10. The formula would be
=SUM(MAX(A1,A2),A3:A10)
or equivalently
=MAX(A1,A2)+SUM(A3:A10)
