Hi,

Am Fri, 25 Apr 2014 09:17:39 +0200 schrieb Claus Busch:

=IF(MIN(IF(B1:G10.5,B1:G1))=0,MAX(B1:G1)-MIN(B1:G1),MOD(MAX(IF(B1:G1<0.5,B1:G1))-MIN(IF(B1:G10.5,B1:G1)),1))

the last posted formula is wrong.
Better try:
=IF(MAX(B1:G1)-MIN(B1:G1)0.5,MOD(MAX(IF(B1:G1<0.5,B1:G1))-MIN(IF(B1:G10.5,B1:G1)),1),MAX(B1:G1)-MIN(B1:G1))
and enter also with CTRL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional