Formula To Return True
 

I need a formula, (not sure if if(countif()) is the right one. I have column
data to look at. I put a filter on column c (blanks) and I need to find
records where there are rows inwhich cells in both column b and d are not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in B and
C are not null.

Formula To Return True
 

try this formula in E1
=AND(OR(B1<"",D1<""),C1="")

-kc
*Click YES if this works

"hilltop55" wrote:

I need a formula, (not sure if if(countif()) is the right one. I have column
data to look at. I put a filter on column c (blanks) and I need to find
records where there are rows inwhich cells in both column b and d are not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in B and
C are not null.

Formula To Return True
 

Maybe something like this:

=AND(B1<"",C1="",D1<"")

Copied down as needed.

--
Biff
Microsoft Excel MVP


"hilltop55" wrote in message
...
I need a formula, (not sure if if(countif()) is the right one. I have
column
data to look at. I put a filter on column c (blanks) and I need to find
records where there are rows inwhich cells in both column b and d are not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in B
and
C are not null.

Formula To Return True
 

It basically works I might have stated incorrectly. I was expecting the
result to say true not false

THREE MONTHS AGO FOUR MONTHS AGO FIVE MONTHS AGO
$749.00 (06/30/2009, loaded 09/14/2009) - $730.29 (04/28/2009, loaded
09/14/2009)
$3,620.92 (06/30/2009, loaded 09/14/2009) - $3,833.25 (04/28/2009, loaded
09/14/2009)
$53.91 (06/07/2009, loaded 07/21/2009) - $53.91 (04/07/2009, loaded
07/21/2009)


"KC" wrote:

try this formula in E1
=AND(OR(B1<"",D1<""),C1="")

-kc
*Click YES if this works

"hilltop55" wrote:

I need a formula, (not sure if if(countif()) is the right one. I have column
data to look at. I put a filter on column c (blanks) and I need to find
records where there are rows inwhich cells in both column b and d are not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in B and
C are not null.

Formula To Return True
 

Hi, works, now if you can answer this one it would be great, how do i adjust
the formula to return only "true" and not the word false?

Jim
"T. Valko" wrote:

Maybe something like this:

=AND(B1<"",C1="",D1<"")

Copied down as needed.

--
Biff
Microsoft Excel MVP


"hilltop55" wrote in message
...
I need a formula, (not sure if if(countif()) is the right one. I have
column
data to look at. I put a filter on column c (blanks) and I need to find
records where there are rows inwhich cells in both column b and d are not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in B
and
C are not null.

Formula To Return True
 

Try this:

=IF(AND(B1<"",C1="",D1<""),TRUE,"")

--
Biff
Microsoft Excel MVP


"hilltop55" wrote in message
...
Hi, works, now if you can answer this one it would be great, how do i
adjust
the formula to return only "true" and not the word false?

Jim
"T. Valko" wrote:

Maybe something like this:

=AND(B1<"",C1="",D1<"")

Copied down as needed.

--
Biff
Microsoft Excel MVP


"hilltop55" wrote in message
...
I need a formula, (not sure if if(countif()) is the right one. I have
column
data to look at. I put a filter on column c (blanks) and I need to
find
records where there are rows inwhich cells in both column b and d are
not
null.

for example

B1 = blue
C1 is null
D1 = yellow then the formula would return true. because the cells in
B
and
C are not null.