Thread: Boolean Math
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otávio Alves Ribeiro Otávio Alves Ribeiro is offline
external usenet poster
 
Posts: 20
Default Boolean Math

Hi there.
The following formula returns true only if A1, A2 and A3 are all TRUE:

=and(A1,A2,A3)

Regards,
Otávio

"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