What's the formula for an IF statement that checks two IsBlank values

[MichaelLindsay]

Hi,

I want to write an IF formula that checks if two IsBlank(X) are both "TRUE", E.g.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Some Text
[/TD]
[TD]Some Text
[/TD]
[TD]Formula Result = FALSE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Formula Result = TRUE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Some Text
[/TD]
[TD]Formula Result = FALSE
[/TD]
[/TR]
</tbody>[/TABLE]

I have found a workaround but would love to know the correct way to do this for future reference.

Cheers,

Michael Lindsay

 

[VoG]

Try

=AND(ISBLANK(A1),ISBLANK(B1))

 

[MichaelLindsay]

Excellent, Thanks VoG!