if anything 2

[SQLScholar]

Hey,

This probably is really easy, but i never needed this before.

Can you tell me how to do a...

IF (Columns A and B and D are blank,"yes","no&quot

TIA

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[SQLScholar]

sorry... i must say, in excel ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[TonyJollans]

Hi,

Everything's easy when you know how. If you put the following formula in E1 it should do what you ask.

=IF(AND(A1="",B1="",D1="&quot,"yes","no&quot

Enjoy,
Tony

 

[SQLScholar]

DOH.... i read about wildcards, and was trying to say IF not "*" and it wasnt working

Thanks

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[mscallisto]

be advised that blank is a character (the space bar makes a blank) and empty or null means exactly that (its clear of characters)

Tony's formula is most likely the format I would use but it only checks for null (empty) cells.

If A1 had a space (the space bar was hit) the test would show "No", if A1 was cleared (Del key) or never used, the test would show "Yes".

If you truly wanted to test for a blank you would need to test for " " not ""

Much Luck

 

[Gavona]

So:
if(trim(a1&b1&d1)="","yes","no&quot
would test all 3 cells for blanks, multiple blanks (e.g." &quot and null.

 

[mscallisto]

You got it!!