Formula To Return True

[hilltop55]

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.

 

[KC]

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

-kc
*Click YES if this works

 

[T. Valko]

Maybe something like this:

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

Copied down as needed.

 

[hilltop55]

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)

 

[hilltop55]

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]

Try this:

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