![Old](images/statusicon/post_old.gif)
7th July 2011, 04:11 PM
|
Banned
|
|
Join Date: Jan 1970
Posts: 147
|
|
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.
|