You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"LisaM" wrote in message
...
These are great! It was 'plain old 0' I was looking for, but I'm learning
a
bit more about how to construct formulae (and the logic behind the
construction) from your examples.

Thank you for all your help. :)

Lisa

"T. Valko" wrote:

For plain old 0:

=IF(COUNTIF(A2:D2,1)=0,0,"07."&IF(A2=1,1,"")&IF(B2 =1,2,"")&IF(C2=1,3,"")&IF(D2=1,4,""))

For 07.0:

="07."&IF(COUNTIF(A2:D2,1)=0,0,"")&IF(A2=1,1,"")&I F(B2=1,2,"")&IF(C2=1,3,"")&IF(D2=1,4,"")

--
Biff
Microsoft Excel MVP