|
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!!! |
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!!! |
| All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com