This formula is supposed to return "NO" if all three conditions are true but it doesn't seem to work. If one or all of the conditions are not true , it is supposed to return "YES".
=IF(AND(C2="FALSE",D2="FALSE",E2="FALSE"),"NO","YES")
Can you assist
Many thanks.
den
If you don't have the quotes round the three instances of FALSE does it work as expected?
BSB
Take "False" out of the quotes and it'll work fine for you.
try:
=IF(COUNTIF(C2:E2,"FALSE")=3,"NO","YES")
If I've helped U pls click on d *Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks