Prev: Save As Macro
Next: Help to resove this problem.
From: JP Ronse on 9 Apr 2010 10:23
Hi jj

Try something as

=COUNT(C26:C28)-COUNTIF(C26:C28,0)

With kind regards,

JP

"jjlang" <jjlang(a)discussions.microsoft.com> wrote in message
news:96E80B98-9DA2-4083-A730-80CFB68E0D16(a)microsoft.com...
> I'm writing an IF function and want my formula to return a 1 if the cell
> has
> a number in it, but return a 0 if the cell is blank of has a zero in it.
>
> ie Cell A1 would return 1 if A2 has 3 in it, but return 0 if A2 is blank
> or
> has 0 in it.
>
>
> Thnanks


From: Ron Rosenfeld on 9 Apr 2010 10:23
On Fri, 9 Apr 2010 06:57:01 -0700, jjlang <jjlang(a)discussions.microsoft.com>
wrote:

>I'm writing an IF function and want my formula to return a 1 if the cell has
>a number in it, but return a 0 if the cell is blank of has a zero in it.
>
>ie Cell A1 would return 1 if A2 has 3 in it, but return 0 if A2 is blank or
>has 0 in it.
>
>
>Thnanks

=if(a2=0,0,1)

or

=--(A2<>0)

or

=(A2<>0)*1
--ron
First  |  Prev  | 
Pages: 1 2
Prev: Save As Macro
Next: Help to resove this problem.