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 num...
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)