Thread: My A1,B1,C1&D1 are 1 but why excel2007 return as false?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default My A1,B1,C1&D1 are 1 but why excel2007 return as false?
That is not a correct syntax for an Excel formula.

This is:

=AND(A1=1,B1=1,C1=1,D1=1)

and it returns TRUE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Narnimar" wrote in message
...
My A1=B1=C1=D1=1 but why formula A1=B1=C1=D1excel2007 return as false?

Reply With QuoteReply With Quote