check range of cells in one step

[panta_rhei]

Hi,

is there a possibility that excel gives me a "true" if a whole range of cells has a "false" in each single cell?

otherwise I would "translate" each "false" into a "0" within a extra line and then just take the sum... but I'm pretty sure there is a direct way^^

thanks!

[shg]

This array formula (confirmed with Ctrl+Shift+Enter instead of Enter):

=AND(A1:A10 = FALSE)

That will count blanks cells as false; if that's not acceptable, then

=AND(A1:A10 = FALSE, A1:A10 <> "")

[panta_rhei]

thanks a lot, it worked out!

didn't know about Ctrl+Shift+Enter!

cheers

[shg]

Great, you're welcome