IF, Or, And, or what

[PA]

Attempting to get a formula to work, with no luck;
Dates will be input into cells G5, H5, I5, and J5.
Formula goes into G6 so that if any of the above four cells in blank, a 0
(zero) is put into G6, if they are all populated return a 1 (one).
I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under all
circumstances. This is obviously the wrong approach.
Any suggestions greatly appreciated.
Paul

[PA]

Sorry, I am going nuts. The formula I tried is

=IF(ISBLANK(OR(G5,H5,I5,J5)),"0",1)

My apologies.

"PA" wrote:

> Attempting to get a formula to work, with no luck;
> Dates will be input into cells G5, H5, I5, and J5.
> Formula goes into G6 so that if any of the above four cells in blank, a 0
> (zero) is put into G6, if they are all populated return a 1 (one).
> I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under all
> circumstances. This is obviously the wrong approach.
> Any suggestions greatly appreciated.
> Paul

[Sandy Mann]

Try:

=IF(COUNTA(A1:D1)<4,0,1)

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk


"PA" <[email protected]> wrote in message
news:[email protected]...
> Attempting to get a formula to work, with no luck;
> Dates will be input into cells G5, H5, I5, and J5.
> Formula goes into G6 so that if any of the above four cells in blank, a 0
> (zero) is put into G6, if they are all populated return a 1 (one).
> I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under all
> circumstances. This is obviously the wrong approach.
> Any suggestions greatly appreciated.
> Paul

[PA]

Works like a charm - Thank you.

"Sandy Mann" wrote:

> Try:
>
> =IF(COUNTA(A1:D1)<4,0,1)
>
> --
> HTH
>
> Sandy
> [email protected]
> Replace@mailinator with @tiscali.co.uk
>
>
> "PA" <[email protected]> wrote in message
> news:[email protected]...
> > Attempting to get a formula to work, with no luck;
> > Dates will be input into cells G5, H5, I5, and J5.
> > Formula goes into G6 so that if any of the above four cells in blank, a 0
> > (zero) is put into G6, if they are all populated return a 1 (one).
> > I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under all
> > circumstances. This is obviously the wrong approach.
> > Any suggestions greatly appreciated.
> > Paul
>
>
>

[Sandy Mann]

You're Welcome.

ISBLANK can only be used with one cell a s cannot cover an array. To use it
the way that you were trying to you would have to use it like:

=IF(OR(ISBLANK(A1),ISBLANK(B1),ISBLANK(C1),ISBLANK(D1)),0,1)


--
Regards

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk

"PA" <[email protected]> wrote in message
news:[email protected]...
> Works like a charm - Thank you.
>
> "Sandy Mann" wrote:
>
>> Try:
>>
>> =IF(COUNTA(A1:D1)<4,0,1)
>>
>> --
>> HTH
>>
>> Sandy
>> [email protected]
>> Replace@mailinator with @tiscali.co.uk
>>
>>
>> "PA" <[email protected]> wrote in message
>> news:[email protected]...
>> > Attempting to get a formula to work, with no luck;
>> > Dates will be input into cells G5, H5, I5, and J5.
>> > Formula goes into G6 so that if any of the above four cells in blank, a
>> > 0
>> > (zero) is put into G6, if they are all populated return a 1 (one).
>> > I tried =IF(ISBLANK(OR(A1,B1,C1,D1)),"0",1), but it returns a 1 under
>> > all
>> > circumstances. This is obviously the wrong approach.
>> > Any suggestions greatly appreciated.
>> > Paul
>>
>>
>>

[Cutter]

Or in G6 type:

=IF(MIN(G5:J5)=0,0,1)

Just an alternative way