Originally Posted by IceTrojan
Another question: How do I ask for the sum of (ColA) + (higher of Col B or C) + (higher of Col D or E)?
Simpler than previously posted solution, using the MAX function that
cordelli beat me to on the first question:
=A1+max(B1,C1)+max(D1,E1)
You can do some pretty fancy things with IF, nesting one inside another if you have to, but there's usually a simpler way to do simple things.