COUNT BLANK AND ZERO AS THE SAME THING

  • Thread starter Thread starter jjlang
  • Start date Start date
J

jjlang

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
 
You can use this IF formula...

=IF(AND(ISNUMBER(A1),A1<>0),1,0)

or you can use this shorter non-IF formula instead...

=--AND(ISNUMBER(A1),A1<>0)
 
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
Click to expand...

=if(a2=0,0,1)

or

=--(A2<>0)

or

=(A2<>0)*1
--ron
 
Back
Top