View Single Post
  #2  
Old 7th July 2011, 05:11 PM
gunny72 gunny72 is offline
Banned
 
Join Date: Jan 1970
Posts: 147
Default

Have the three margins in three columns, and use the SUM and MAX functions, eg, SUM(A1:C1)-MAX(A1:C1) . This adds all three margins and subtracts the largest leaving the sum of the smaller two, which is what you want.
Reply With Quote