Need Formula - If blank cells

[hilltop55]

I need a formula to return true, based on cells in column b being blank.

So if A1 is not blank, B1 is blank, and C1 is not blank return true.

 

[Jacob Skaria]

=AND(TRIM(A1)<>"",TRIM(B1)="",TRIM(C1)<>"")

If this post helps click Yes

 

[Mike H]

Hi

Try this for a blank cell where a formula is returning null

=B1=""

or for an empty cell

=ISBLANK(B1)

Mike

or



Mike

 

[Luke M]

=COUNTA(A1:C1)=3