Claus Busch wrote:

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

Amazing. Works like a charm. Thanks for your hard work.

--
Mom used to tuck me into bed at night.
She'd kiss me on the forehead and say, "Nighty-night."
Then Dad would tiptoe in and whisper, "Beware the chicken!"