13th June 2006, 04:40 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Sorry JFC
It doesn't work. Problem is I can have just one column with a figure above 0 and the other two are 0. The example below is the sort of data I have in the three columns. Just want add the two highest columns and devide by 2.
46, 0, 0
48,46,42
54,42,36
Twodogs
|
=if( median(a1:c1)>0,(sum(a1:c1)-min(a1:c1))/2,max(a1:c1))
Try asking the right question.
Is this your school homework? |