Thread: Logical test
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Logical test

The function you are writing will always return FALSE, since A8
will be either TRUE or FALSE, never both. However, in general
terms, you use the AND function to test more than one condition.
E.g.,

=AND(ISBLANK(A8)=TRUE,ISBLANK(A8)=FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"mathew" wrote in message
...
I'm sure this is an easy one for you guys! I'm trying to use

this logical statement as a conditional format for an input
cell. The logical test comes back as an error. I don't know
why! How do you combine logical test?
=ISBLANK(A8)=FALSE & ISBLANK(A8)=TRUE

I need some help!!!