Boolean Math
You don't need =IF(...,TRUE,FALSE)
Your formula is the same as =COUNTIF(D5:D7,"true")=3 or
=COUNTIF(D5:D7,TRUE)=3
but AND is easier.
--
David Biddulph
"FrankWood" wrote in message
...
Assuming your cells are D5:D8 you could use this:
=IF(COUNTIF(D5:D7,"true")=3,TRUE,FALSE)
Hope that helps,
Frank
"Art" wrote:
I have three cells with formulas that return a boolean value.
I need a formula in the fourth cell that returns True only if the first
three cells are all True.
--
Thanks,
Art
|