Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Logical test
Chip: Thank you!
"Chip Pearson" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use 'CONTAINS' in an IF Logical Test? | Excel Worksheet Functions | |||
IF Logical Test | New Users to Excel | |||
Logical Test | Excel Worksheet Functions | |||
Logical Test | Excel Worksheet Functions | |||
Logical test | Excel Discussion (Misc queries) |