Boolean Math
This slightly shorter AND method seems to work also (assuming the cells are
contiguous)...
=AND(A1:C1)
or
=AND(A1:A3)
--
Rick (MVP - Excel)
"Art" wrote in message
...
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
|