Re: Value Return

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.
"rsenn" <rsenn.2007jm_1134519902.2027@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:rsenn.2007jm_1134519902.2027@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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 other
> than numbers and letters, such as the % sign?
>
>
> --
> rsenn
> ------------------------------------------------------------------------
> rsenn's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=29050
> View this thread: http://www.excelforum.com/showthread.php?threadid=493233
>


.

Relevant Pages

  • Re: Autopopulating a cell
    ... an entry into the a1 cell. ... Tralee6 ... Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 ... Prev by Date: ...
    (microsoft.public.excel)
  • Array Reference
    ... value of a cell? ... accross. ... anar_baku's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18259 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Help
    ... Use the 'Goal seek' option on the 'Data' menu to find the value of cell ... Deadloss ... Deadloss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29859 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Adding a column
    ... If there is only one number in cell it is counted, if 2, then the one ... in parentheses is the only one of the 2 counted. ... roger_home's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16434 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Re numbering the row.
    ... Your could use the ROWfunction in each cell where you want row ... rsenn's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29050 ... Prev by Date: ...
    (microsoft.public.excel.misc)
Loading