Thread: Using the highest 2 out of 3 values in a formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
christopherp
 
Posts: n/a
Default Using the highest 2 out of 3 values in a formula

Thanks for the responses guys - I have solved the problem with your
help.

This is the formula I have used and it works fine:

=F24+(SUM(F18,F20,F22)-MIN(F18,F20,F22))+(SUM(F19,F21,F23)-MIN(F19,F21,F23))

F24 is a constant and will be included in the calculation regardless of
other results.

Thanks again

Chris


--
christopherp
------------------------------------------------------------------------
christopherp's Profile: http://www.excelforum.com/member.php...fo&userid=4162
View this thread: http://www.excelforum.com/showthread...hreadid=518167

Reply With QuoteReply With Quote