Value Return

[Frick]

In cells from C2:K2, some cells have either a number or a letter. What I
like to have is a formula like If(sum(C2:K2) have anything in them numbers,
letters, return value 1, otherwise return 0) It's easy if there are numbers
in any given row, but the letters are throughing me off. How can this be
handled.

 

[rsenn]

What do you want your answer to be if some of the cells have numbers
some have letters, some have blanks, and some have characters othe
than numbers and letters, such as the % sign

 

[Frick]

If there is anything in the range I want it to return a value of 1 otherwise
a value of 0.

For example: If(sum(A2:G2>1,1,0) In this formula if there is any number in
any cell I would be a value of 1 if not I would get a value of 0.

My problem is that in some rows I might not have a number in any given cell
but may have a letter like A or G or whatever. In those rows if any cell
has a letter I need the target formula to still return a value of 1
otherwise 0.

I hope that clears it up.

 

[RagDyer]

Try this:

=--(COUNTA(A2:G2)>0)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[rsenn]

Okay, try this.

=IF(ISERROR(CODE(A2:G2)),0,1)

 

[rsenn]

Take that back. I didn't test it sufficiently. It behaves erratically.

 

[rsenn]

Sorry about that.

Try
=IF(ISBLANK(A2:G2),0,1)