Thread: Boolean Math
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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